Skip to Content
0
Aug 03, 2023 at 10:28 AM

From date to the end of year - SAC Sript

111 Views

Hey,

I have a Forecast year set as a memberset,

I want to fill data as of "chosen month" to the end of the forecast year.

I wrote the below code (that is valid)

but It just doesn't work

what do I miss?

(without the "IF" my formula works well)

Thank you

 

MEMBERSET[d/Measures]="VALUE"

MEMBERSET[d/Date]=BASEMEMBER([d/Date].[h/YM] , %P_04_FORECAST_YEAR%)

MEMBERSET[d/PLM_ACC]=("KT10","KT17","KT35","KT36")

IF MONTH([d/Date])>=RESULTLOOKUP( [d/Date] = %P_02_REP_MONTH_ACT%)

THEN

DATA([d/PLM_SIMULATION]="SIM_MIX")=

RESULTLOOKUP([d/PLM_SIMULATION]="#", [d/Version]="public.Budget")

ENDIF