Hi,
Please could you help me understand which setting i have incorrectly which is populating my actuals in advance in image 1? Image 2 is correct.
Check if your switchover is at Sep 21. Switchover settings are located in versions settings
@lcapon
Are you using IF ELSE statements on TIME dimension? If so then it is worth taking a look at
Misbah
@KirillKuznetsov
Switchover doesn't apply to Actuals. Its the other way around - copying data from Actuals to any other Version member
Thanks - the IF statements in place are an exact replica in both screen shots.
I dont know what else is driving this.
Are you refering to this section?
No, Go to Module blueprint mode and share the formula that is being used in the line item. You don't need to share the numbers related to it - just the formula will be enough
FTE - IF Current Employee THEN 'ES005 Employee Details'.FTE ELSE 0
Mat Leave - IF 'ES005 Employee Details'.'Maternity/Long Term Sick Start' <= END() AND 'ES005 Employee Details'.'Maternity/Long Term Sick End' >= START() THEN 'ES005 Employee Details'.FTE ELSE 0
Head Count - IF Current Employee THEN 1 ELSE 0
Mat Leave Head Count - IF 'ES005 Employee Details'.'Maternity/Long Term Sick Start' <= END() AND 'ES005 Employee Details'.'Maternity/Long Term Sick End' >= START() THEN 1 ELSE 0
Vehicle Allocation - IF 'ES005 Employee Details'.'Car/Van Allocation' THEN 1 * Head Count ELSE 0
Which specific line item were you looking at when you posted the query?
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
Kindly assist me to load data into the model.
Hello , Facing an error in looging in support portal , can anyone assist
