Calculation Functions

Apps > Report: Add Variance between rows
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 this is currently unavailable. It would be greatly appreciated if this feature could please be added as soon as possible so we…
I want Booleans as true as per below requirement
Boolean with summary : "all", true for parent with no child?
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 summary was set to ALL even if it had no children. Why is this so? I thought if summary is set to ALL the parent would be true if…
OEG Best Practice: Formulas and their effects on model performance
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 does not prevent from adding extra line items, it's a better practice to create multiple intermediate line items and reduce…
Level 2 Sprint 2 2.3.10
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 (DEM01) - DEM02 screenshot 2 (DEM02) - DAT03 screenshot 3 (DAT03) - Formula: IF 'SYS01 Time Settings By Week'.'1st Forecast…
3.3.12 Activity: Create Product Replenishment UX Page - Conditional Formatting
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 as red when the value is less than the Safety Stock Target value. See below the options I see for conditional formatting,…
Level 2 Conclusion INV05 Shipping Export
@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 because the formulae I have entered is wrong?
Calcuation of subsets as my allocation basis
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.
Update Historic Volumes for Baseline Forecast
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 Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast…
IRR function to operate on a specified time period ranges
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 IRR calculation when the sign of the cash flows changes more than once, for example when positive cash flows are followed by…
Level2 Sprint3 3.3.5.3 Check Your Work
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:
OEG Best Practice: Anaplan Performance Triangle
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 triangles, where scope, time and cost control quality, this will be familiar. It is a good way to show the constraints of any…
12.4.2 Create Saved View for Country Margin Report
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 modules. Please send suggestions
How to refer a properties in formulas
Hi, How can we refer properties in formula
Level 1 Lesson 11.3.4 Activity: Add Formulas to Profit and Loss Report Module
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 FormulaError message displayed for the formula Further, I would like to know whether the formula repeats itself for all the…
Level 3 Sprint 2 Assign action [Finalize Assigments button error]
Hi Good day, Invalid selection message Can anyone give me some hint? Thanks
Error message L1 model building - 6 Module 6.6.5
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 list member I received this error message when I try to enter formula to the line item Forecast Year And I am also not sure…
L2 Sprint 3 - 3.3.6
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 formulae: PO Submitted: IF Submit Purchase Order Request? THEN 1 ELSE 0 Confirmed PO Delivery: POST(PO Submitted, Final…
L2-Sprint 2, DEM03 module
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 data from 2019 to 2020 by applying OFFSET function. In DEM03 module, for Baseline forecast line item we applied a formulae…
Allocate a summary level data input into other
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 thousands of products in the country, so I don't really want to have to enter the same growth number multiple times. However, I…
Options to improve performance when loading flat list used in reporting
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 lists + time and also requires summary to be on so data can be reviewed at aggregate levels. As a result the import action…
Refering to data in previous item of a list
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 line items in my module, namely the principal amount, increase rate (different for different time periods and events) and a…
Summarizing only Negative numbers and Positive Numbers in separate Line Items
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 same product. (eg: Apples in December 2020 had one adjustment for -10 and another adjustment for 20. The Net effect of these…
Level 2 Model Building Sprint 3 3.3.5Activity :Create Inventory Ordering.
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 week 5 3. Shipping methods are not visible although I've put formula there 4. Shipping time weeks are not showing any data 5.…
G4T territory
Can anyone please share screenshot of this list. I am trying to upload CYW file, but its not working. Please advise. Thanks -Pooja
Level 2 Sprint 3 Ending Inventory
Hi, I am getting circular referencing error when use the formula to calculate the ending inventory as follows: Ending Inventory = Beginning Inventory + Confrim Purchase Order Receipt- Forecast Demand Error Message: Circular references: Ending Inventory, Safety Stock Exception Count, Confirm Purchase Order Receipt,…
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hi, I'm having a hard time understanding the ask here. First, I added Write Access drivers for line items. Snapshot below Then, added formulae for the AD02 Inventory Ordering Overrides What is the results being referred to in the ask. Appreciate the guidance here! Not making progress and not understanding the ask here.
Assigning accounts to territory
I am not getting any reference on how to assign accounts to territory. Can anyone please give any hints.
Firstnonblank formula not working
Hi, I'm trying to create a line item with the "firstnonblank" formula but it's not working. I have 3 line item : * line item 1 = hub (let's say "1"or "2") * line item 2 = some text but not everywhere * line item 3 : i want to have the text of line item 2 but for each item in the same hub I join a screen which is way more…
Level 3 Sprint 2 : Assign > 1?
'SYS06 Territory Account Details'.Count[SUM: Account Name] Can someone help me understand what am I missing here? Thanks

Calculation Functions

Discussion List