Changing formula scope does not re-apply to line items?

DeveloperCYT · 2023-09-07T07:39:27+00:00

There was an error rendering this rich post.

I have a formula which was written with the formula scope set to 'All Versions', then realised that I only need it to apply to 'Current Version', so I changed the scope but the data is still showing in the actuals and the forecast (all versions).
If i add a new line item and set the scope first, and then use the exact same formula, it only shows the data in the forecast as expected.
Is there a way to change the formula scope and apply it, I have tried deleting the formula, changing the scope and entering formula again, but it seems the old versions data is not being removed or replaced.
thanks

Accepted answers

pyrypeura

Hi, one option to get rid of data on other versions would be to set formula scope to All Versions and formula to 0. Then remove formula set formula scope only to Current version and then reinput the original formula.

All comments

pyrypeura

DeveloperCYT

Sounds like a solution. Thanks

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
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…