Skip to Content
1
Nov 02, 2020 at 03:08 PM

SAC- DATA Action- Advanced Formula Action

506 Views

I would like to Have Prompt to choose Time period(Year) while triggering data action to copy Quantity and calculate price.

like below standard formula where i managed to include version To and From while executing Data action, but unable to set prompt selection option for From Period to TO Period (Year)

//Parameters and Scope MEMBERSET[d/Date] = [d/Version].[p/StartDate] to [d/Version].[p/EndDate] MEMBERSET [d/SAP_FI_BPL_GLACCOUNT] = BASEMEMBER([d/SAP_FI_BPL_GLACCOUNT].[h/Hierarchy],"022" ) MEMBERSET[d/SAP_FI_BPL_FIXVARIABLE] ="#"

VARIABLEMEMBER #AMOUNT OF [d/MEASURE]

VARIABLEMEMBER #DATE OF [d/Date]

//Only copy quantity where value is not equal to 0

IF (RESULTLOOKUP([d/MEASURE]="QUANTITY", [d/Version] = %FromVersion%, [d/Date] = PREVIOUS(12)) !=0) THEN //Copy Quantity from last year actuals

DATA([d/MEASURE] = "QUANTITY") = RESULTLOOKUP([d/MEASURE] = "QUANTITY", [d/Version] = %FromVersion%, [d/Date] = PREVIOUS(12))

Here i would like to have Prompt Variable to select from to period instead of fixed value: Previous(12).

Thanks in Advance !!!