Dear Model Builders,
Please refer my attachd Opening Capex code which I believe not referring to the previous month's closing capex correctly.
Appreciate your help on finding the cause of error and possible solutions.
Thanks
Hi @TD1,
Simplifying the formula will make it easier to understand and troubleshoot, while also reducing the calculation effort % of this line item and improving your model's performance. This line item probably has high calculation effort due to multiple nested IF statements. Here are a few suggestions:
2. Consider separating ITEM(FV01 Versions) in your versions system module if you have 10+ versions.
3. Try to move this part to a system module, too.
These will make the formula easier to fix.
I hope this helps.
Seyma š·š
Here is an example of how a simple If+Boolean formula optimization can reduce the calculation effort:
Formatted Sales 2 Formula - Calculation Effort = 27%
IFĀ Ā Ā Ā 'SYS01Ā SalesĀ NumberĀ Units'.NumberĀ UnitĀ InputĀ =Ā 'SYS01Ā SalesĀ NumberĀ Units'.Thousands THENĀ Ā Ā Ā SalesĀ /Ā 1000 ELSEĀ IF 'SYS01Ā SalesĀ NumberĀ Units'.NumberĀ UnitĀ InputĀ =Ā 'SYS01Ā SalesĀ NumberĀ Units'.MillionsĀ Ā Ā Ā THENĀ Ā Ā Ā Ā SalesĀ /Ā 1000000Ā Ā Ā Ā ELSEĀ Ā Ā Ā Ā Sales
IFĀ Ā Ā Ā 'SYS01Ā SalesĀ NumberĀ Units'.NumberĀ UnitĀ InputĀ =Ā 'SYS01Ā SalesĀ NumberĀ Units'.Thousands
THENĀ Ā Ā Ā SalesĀ /Ā 1000
ELSEĀ IF 'SYS01Ā SalesĀ NumberĀ Units'.NumberĀ UnitĀ InputĀ =Ā 'SYS01Ā SalesĀ NumberĀ Units'.MillionsĀ Ā Ā Ā
THENĀ Ā Ā Ā Ā SalesĀ /Ā 1000000Ā Ā Ā Ā
ELSEĀ Ā Ā Ā Ā Sales
Formatted Sales 1 Formula - Calculation Effort = 60%
IFĀ Ā Ā Ā 'SYS01Ā SalesĀ NumberĀ Units'.'InputĀ =Ā Thousand?' THENĀ Ā Ā SalesĀ inĀ Thousands ELSEĀ IFĀ 'SYS01Ā SalesĀ NumberĀ Units'.'InputĀ =Ā Millions?'Ā THENĀ Ā SalesĀ InĀ MillionsĀ Ā Ā Ā ELSEĀ Ā Ā Ā Sales
I'd like to note that calculation effort can fluctuate depending on factors like early exit logic, but the main idea here is keeping formulas short and clean improves performance and makes them easier to read.
Hope this helps! Seyma š·š
If you want to match numbers, try using PREVIOUS.
PREVIOUS('DEP10 Closing Capex')
Something like this:
IF 'SYS02 Time'.Is First Month THEN [Your IF-ELSE logic here] ELSE PREVIOUS('DEP10 Closing Capex')
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL commentsā¦
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!
Hi, Iām experiencing a strange issue in ADO that I canāt seem to resolve. Before reaching out to Anaplan Support, I thought I would check with the community for advice. Iām trying to extract some list properties for an ADO mapping from a Polaris model/module. However, no matter what I do, I keep encountering the same errorā¦
