
Calculation Functions
Calculation Functions
Discussion List
- Hi community! I couldn't find any information on whether it's recommended to split SELECT and LOOKUP for better performance. This thread helped me to understand that SELECT works in a similar way as L…
- Hi! For example I have 4 versions namely: Actual, Budget, Forecast 1 and Forecast 2. Does Anaplan allow different formula for each version I have in my module? Say, Actual version will have a differen…
- What is the Optimizer Toolbox? The Optimizer Toolbox is a Model Builder’s reference guide that details common linear program constructions for themes such as allocation, scheduling, and time-phasing. …
- Hi So I am having a bit of an issue I need to do a calculation monthly, but I need to refer back to the previous year end balances as my start point for all months. I tried doing it with offset, why I…
- The new feature in Apps > Report to add variance between columns (as shows in the screenshot) is fantastic. It would be very useful to have the same feature to calculate variances between rows, but th…
- Why is a Boolean line item with summary set to ALL true for Parent even when there are no child items? I noticed that a boolean line item was true for a parent in the hierarchy automatically if summar…
- Details of known issues Challenge Recommendations Performance issues with long nested formulas Need to have a long formula on time as a result of nested intermediate calculations. If the model size do…
- Hi, as a result for the first question (2.3.10) I have the answer 71.34 but it should be 73.48. I don't seem to understand where I made a mistake. Could anyone help me out please? - DEM01 screenshot 1…
- Hi, For this section of Activity 3.3.12 regarding conditional formatting, I have not been able to find the rule to reflect the condition below: * Add conditional formatting to display Ending Inventory…
- @Misbah Shipping Costs = 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] This formula for the shipping costs line item is giving me '0' as values. Is it b…
- Hi guys, how can i get the totals of my subsets in my formula so the totals of my denominator will only be the totals of the subsets? Thanks in advance.
- Hi Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Fore…
- Hello team I would propose an idea of IRR function enhancement to operate on more dynamic environment and respect Anaplan time dimension in the same way as TIMESUM function. Why it is necessary? For I…
- Hello all, After inserting the formulas to INV01, my numbers aren't exactly the same as the screenshot on the instruction. Where I might've made mistakes? This is my blueprint view:
- Building well performing models is a balance between the complexity and functionality of a model versus the number of concurrent users. If you have seen software development / project management trian…
- Hi, I'm working on Lesson 12 in Level one. My issue is that the example data is slightly different from what I've been building so far. I'm not sure if it's the format or formula from the other module…
- Hi, How can we refer properties in formula
- Hi I have a problem in fixing the formulas for the above lesson. I have attached the screen shots for the first formula I was supposed to create which is for Headcount. REP03 Profit & Loss Headcount F…
- Hi Good day, Invalid selection message Can anyone give me some hint? Thanks
- The formula for 'SYS01 Time Settings by Year'.Forecast Year? is invalid: Forecast Year? = 'SYS00 Time Settings'.Forecast Period? 'SYS00 Time Settings'.Forecast Period? is not a recognized line item or…
- Can anybody please help me with why my data is showing 0 instead of 16388 in Confirmed Purchase Order Receipt (week 3) after following the instructions in the screenshot? I have applied the following …
- Hi, In L2-Sprint 2, DEM03 module we created few line items and applied some formulaes, after applying formulaes the data is populated for only FY2020 since we have only 2019 actual data we pulled the …
- Hello, In one module, I want users to enter one growth number for a country. I then want that growth number to be applied to every single product in that country (in another module). There are thousan…
- Hello, I'm loading flat data between 2 Anaplan models and in the target model, I'm using the Sum function to dimensionalize the flat data into a reporting module. The reporting module needs to have 5 …
- I have pulled a list in a module and this list contains data for various events. Now I want that the calculation on any event in the list to act on the data on the previous list. Example: I have 3 lin…
- Hello, I am trying to solve a dilemma. I have values for a list property called "adjustments". These values can be positive or negative and there can be more than one in the same time period for the s…
- Hello! I'm stuck in 3.3.5 Activity which is to Create Inventory Ordering. I am facing multiple issues like 1.In begining inventory from week 5 data is incorrect. 2. Reordering flag is not there in wee…