Skip to Content
1
Aug 30, 2018 at 06:56 AM

SAC - Data Actions - Advanced Formulas action

8475 Views

Hi Folks,

trying out data actions - advanced formulas and struggling a bit...

Intention:

Copy value of a account figure from on day to all other days of the year.

Code:

// Working
MEMBERSET [d/Account].[p/ID]= "G1000"
MEMBERSET [d/Time].[p/DATE] = ("20180101","20180102","20180102")

// Not working
//MEMBERSET[d/Time].[p/DATE] = "20180101" TO "20181231"
//MEMBERSET[d/Time] = "20180101"

FOREACH [d/Time]

// Not working at all
//DATA([d/Account]="G1000")=RESULTLOOKUP([d/Account]="G1000",[d/Time]="20180101")
DATA([d/Account]="G1000")=RESULTLOOKUP([d/Account]="G1000",[d/Time].[p/DATE]="20180101")
ENDFOR

Issues:

MEMBERSET does not recognize the day range with to

->Mismatching input 'TO'; expecting EOF

Nor a single day

-> Member not found

Also if I try quarter or year it tells

-> 2018 is no leave member.

In Resultlookup it seems I cannot use .[p/DATE]

-> Error Mismatching input 'd/Time].[p/DATE]

So I guess I use the wrong syntax for values for the [d/TIME] in general.

Can somebody post an example how to set a day range / use day in RESULTLOOKUP.

(search did not bring up any). Or tell me what I am doing wrong?

Thanks and best regards,

Axel