Swtichover set to False driving Formula error

Hi team,

I have a Line Item where the Formula Scope = All Versions & Use Switchover = True. When I turn the Switchover off I receive a 'Formula is invalid' error

I have tried removing the formula, setting Switchover to False & return the formula by the same error ocurrs

I cannot see why this error would be happening. My understanding is that nothing changes in the calculation except that it now applies to all the Time Periods rather than 'Current Period' plus future months?

Thanks

Mark

Accepted answers

All comments

nathan_rudman

is one of the component of your formula pulling from a line item that as the the formula scope of Actual only ?

MarkTurkenburg_*8288

Hi Nathan, No both referenced Line Items have the formula scope of All Versions Thanks

nathan_rudman

including the LOOKUP and the SUM ?

MarkTurkenburg_*8288

Hi Nathan,

No they are both fine too

For transparency I have included all the Line Item detail below

Thanks for your help

Formula Line Item

EM25 Referenced Line Items

EM45 Referenced Line Item

T_Caban

Hi Mark,

I noticed that you used a different Time Ranges In EM 46 and EM25 modules. Could you send a screenshots with Time Ranges setup (from Time) and Switchover setup (from Versions)? It should be helpful in investigation.

Regards,

Tomasz

MarkTurkenburg_*8288

Hi Tomasz,

Please see screenshots below

Thanks

MarkTurkenburg_*8288

I have isolated the problem to the [ SUM: 'EM25 - Employee Expenses'.'#Job Role'] portion of the below formula

'EM25 - Employee Expenses'.'Salary (Used)'[ SUM: 'EM25 - Employee Expenses'.'#Job Role']

I cannot understand why the error is occuring when I untick 'Use Switchover' in EM46

My understanding would be that the value in the versions other than Actual would continue to be generated using the formula from those versions, rather than the Actuals version value flowing through for any Time Period pre Current Period

nathan_rudman

what's in EM41 ?

MarkTurkenburg_*8288

Hi Nathan,

EM41 - #Job Role line item below

Thanks

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…