write the following code in Anaplan.
Hello everyone, I have two questions. Firstly, I am attempting to write the following code in Anaplan, I am using a calendar time setting (time scle :week) picture attached.
IF Week = 'Week N' (where in my model N=25, representing the 25th week of the year) THEN
Flux_Disp = Starting_Stock - Security_Stock - Demand_Global;
ELSE IF Week = 'Week N+1 ' THEN
Flux_Disp = Final_Stock_of_Week N- Security_Stock - Demand_Global;
Flux_Disp = 0;
Could you please confirm if this code can be written in Anaplan? and how ?
Secondly, I would like to know if there is an equivalent formula in Anaplan for the Excel function AROUND.MULTIPLE.
thanks in advance.