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?
I have tried a few different ways and have not come up with these numbers.
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.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…