Same line item to be editable and formula based

I have one line item and I need data to be formula based for first 5 years (Already defined in a sys time module) and next 5 years (i.e future years) to be manually inputted. We dont want an extra line item for that editable part. How can I do this.

Accepted answers

All comments

Sampriti.Anand

Hi @Soumyajit,

If you are using native versioning in your model, then with switchover you can manage to have one common line displaying actuals and being editable at the same time.

Apart from it unfortunately, it won't be possible to have one same line item editable and formulated at the same time.

Thanks!!

seymatas1

Hi @Soumyajit

There are three ways to bring numbers into line items in Anaplan:

1. Formula writing

2. Manually inputting numbers

3. Running an action

It is not possible for a single line item to be formula based and editable for different time periods other than Sampriti mentioned.
You can accomplish this by combining two separate line items. What is your concern about adding a line item? Do you have too many dimensions and large lists in that module?

rob_marshall

@Soumyajit

If you are using Native Versions, @Sampriti.Anand is 100% correct. And you can use the formula scope (in the blueprint) to define where your actuals are coming from.

PulkitChawla

Hey @Soumyajit,

As mentioned by Sampriti above, it is possible with native versioning only.

Otherwise there is no way to achieve this.

Kanishq17

Hi , I dont think this is possible , Maybe if versions are there this is possible

Thanks

Kanishq

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…