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.
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!!
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?
@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.
Hey @Soumyajit,
As mentioned by Sampriti above, it is possible with native versioning only.
Otherwise there is no way to achieve this.
Hi , I dont think this is possible , Maybe if versions are there this is possible
Thanks
Kanishq
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it'sā¦
Hi All, I want to address an query related to exports, In Output model, which is read access for all users & roles.user want to have dynamic export depending on user selection of multiple regions. So for selected regions , they will be able to see the data only for selected regions. Thanks,
Kindly assist me to load data into the model.
