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?
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…