D3 and mvBase

ROCKETEER Brian Cram posted 05-28-2021 12:42

I know nothing of SS, but I'd be willing to guess that A7 is not being used. Try replacing A8 with the content of A7 and leave A7 blank. The simple analogy about conversions and correlatives I've used in the past is:

Correlative: "this is what I am"
Conversion: "this is what I look like"

Walter Kiess posted 05-31-2021 19:20

I'm no DICT Guru, correlatives and conversions give me a headache...and I've never used SS.
I've been taught that a conversion is used to display the data in a format you want to see whereas a correlative is used to convert the data into a format you want to use for selections.
I've recently had a similar case where I thought I had to use A8 to extract the data from the attrib before applying the conversion, but that wasn't the case. Even though it worked when doing a plain old LIST, when I used it in another formula it didn't work. It seems the AQL preprocessor is too smart for its own good and works its special magic on the data so I don't have to. By including my own correlative I was confusing the AQL preprocessor thus yielding the incorrect result.
In your case, I'm wondering why you have G2$1 in A8? The conversion in A7 is applied to the data after the correlative is applied, but the conversion uses A0 instead of the result of the correlative, so the correlative becomes redundant. Try leaving A8 blank. If SS works on displayed data, then just A7 on its own should do the trick.

ROCKETEER Brian Cram posted 06-01-2021 17:38

Couldn't do it with one ADI, so here's three:

year
001 a
002 0
003 year
004
005
006
007
008 a;0(g2$1)(dy)
009 r
010 4

mo
001 a
002 0
003 mo
004
005
006
007
008 a;0(g2$1)(dm)(mr%2)
009 r
010 2

period
001 a
002 0
003 period
004
005
006
007
008 an(year):n(mo)
009 r
010 6

Bill Brutzman posted 06-01-2021 17:44

I find that doing these sorts of things in UniBasic is an easier way _ especially when multiple persons are involved.