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