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 !!!