Is it a Bug?

I have a dimensionless module with two line items

Line Item 1: Amount (No TimeScale, No Versions applied) - Number formatted

Line Item 2: Absolute (No TimeScale, No Versions Applied) = Absolute value of Line item Amount

Change the Formula Scope of the Line item Absolute from "All Versions" to "Actual Version" or "Current Version" the number becomes editable. How is Anaplan making the number editable when there are no versions applied and changing the formula scope shouldn't have made any difference. Is it supposed to work this way - I hope not.

Post Changing Formula Scope from All Versions to Actual Version

Let me know your thoughts

Misbah

Accepted answers

All comments

naushad786

Hi @Misbah,

If you are applying Formula scope to the line item then you must have Version applied to it. it will work then.

Please see the below link.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_Formula_Editing.html#EditingFormula

Thanks,

Naushad

Misbah

@naushad786

Agreed! (Formula Scope is dependent on Versions as dimension)

But the point I was trying to highlight is when there are no versions applied Formula Scope shouldn't apply either.So basically system should see if there are versions in dimensions then only formula scope should apply, otherwise not. As you can see in below screenshot it is not happening - System makes cells editable based on the Changes in Formula Scope when there are no versions applied.

Hope that makes sense

Misbah

Yash1

Hi @Misbah ,

I think this behavior is specifically for Actual Version. System allows you to Input value for Actual version, whereas if you choose, let's say "All Versions except Actual" , the cell would again become read only.

Let me know if this provides some clarity.

Thanks,

Yash

Misbah

@Yash1

Appreciate that! If you take a look at my initial query - I have mentioned it that it happens only to Actual version and Current Version. But the basic question still remains unanswered -Why should the Formula Scope be applied (Be it to only few) when there are no versions applied? Is there any logic that can supplement it?

Thanks,

Misbah

LipChean_Soh

Hi @Misbah

I see your point though technically it is doing what it says it's doing, i.e. apply formula only to 'Actual Version'. Note that this also applied 'Current Version'.

Having said the above, I also appreciate that it does the following:

1. If there is a formula + Formula Scope = Actual Version/ Current Version; then assuming a value is entered into this line item, this value will be lost if the model builder later realized his mistake and updated Formula Scope to 'All Versions'.

2. This is not easy to debug, because it's a specific setting in a specific module.

Based on your observation, i have created an entry in Ideas Exchange

https://community.anaplan.com/t5/Idea-Exchange/Deactivate-Formula-Scope-if-Versions-Not-Applicable/idi-p/60627

If we get enough upvotes, it'll get some attention with the Product/Engineering team.

Once again, nice observation there ...!

Thanks,

LipChean

Misbah

@LipChean_Soh

Thanks! I have already upvoted for it.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…