nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Actuals

lcapon

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.

Accepted answers

All comments

KirillKuznetsov

Check if your switchover is at Sep 21. Switchover settings are located in versions settings

lcapon

Misbah

@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

Misbah

KirillKuznetsov

Sorry, i read your image incorrectly. Could you please show the formula?

lcapon

Thanks - the IF statements in place are an exact replica in both screen shots.

I dont know what else is driving this.

KirillKuznetsov

You are correct, I didn't see the page selector value

lcapon

Are you refering to this section?

Misbah

@lcapon

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

Misbah

lcapon

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

Misbah

@lcapon

Which specific line item were you looking at when you posted the query?

Quick Links

Can you help?

Unanswered questions

L3 Sprint 2, User Story 3.3 Q1 Quarter Allocation
Hi Community, It appears that values shown here for Q1 are assuming 29 days in Feb 25, when there are actually only 28. My values tie out for all Quarter values and all months shown from Apr 25 forward, and it's not possible for only a single quarter/finite range of months to differ with formula-driven values: Please…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
Looking for Anaplan End-Users to take a short survey!
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.…