Calculation Functions

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
Ragged and Balanced Hierarchy help. Many to Many relationship with Ragged Hierarchy.
Hi Community, I have been reviewing the knowledge around Ragged and Balanced hierarchy. I have a bit of a unique situation and need some help from the Community. Attached is a file that breaks down the flat file I have put together of a relationship between entity-owner. Each entity has an owner. That owner can also be an…
How do I have a different summary method for a single line item?
I have three line items: budget, reforecast, and variance. My dimensions are three different lists - type, subtype & quarters. Some of the subtypes for budget and variance need to be sums and others are closing balance. What would be the most efficient way to do this?
Rankcumulate with Multiplication
I use the rankcumulate with for allocation. I have come across something that I don't have a solution for: Compounding percents within a list of data. This could be used for compounding mardowns for pricing to see the aggregate affect. Example soming costs $100. I take a 20% price reduction in the first period and then…
In anaplan model testing , Is it possible to do automated testing?
What are the tools we may use to test anaplan ?
MailTo Limits in Firefox vs. Chrome
We are using the MAILTO function to generate an email to a BCC-ed list of users of action required in the model. The list of BCC recipients is lengthy (>100 email addresses), and the MAILTO function appears to work in Firefox, but not Chrome (OS = Windows, email client = Outlook). Has anyone run into similar limits? Are…
OEG Best Practice: Reduce calculations for better performance
Reducing the number of calculations will lead to quicker calculations and improve performance. However, this doesn’t mean combining all your calculations into fewer line items, as breaking calculations into smaller parts has major benefits for performance. Learn more about this in the Formula structure for performance…
Create ABORT button when getting stuck with changes/formula when you made mistake.
When submitting changes to line item, and you know you did mistake. Please let us ABORT calculation by Anaplan. It will save tie and resources when building model.
Working Days Calculation
Hi, I have been using the long formula for working days suggested in the Anaplan help, and it's been giving me some issues, so I created a new one It's shorter and easier to follow and thought I would share You need 5 fields* *Holidays is optional and can be removed example of calcs Hope it helps Kev
Number of working days in a month
Excel uses the formula function NETWORKINGDAYS to calculate the number of working days in a month How would I do this in Anaplan? Link to an input module?
How to get data from source module with time dimension to target module without time dimension
Dear Team, Hi again! I would like to inquire on how to get data from source module with time dimension to target module without time dimension. For illustrate further: Module 1 - Upload of Year to date balances - with time dimension (Month) Module 2- Deduct the current period(month) from previous period(month) to arrive at…
Finding the first working day of the month
Hi guys, I am trying to create a calendar. In this calendar I need to pull out the first working day after day X. For example : I have a module with holidays, working days etc. as booleans and on the other side I have 1st of january 2nd etc. Let's imagine the 1st of jan is a saturday. I would like then to check the 2nd of…
Compare numbers in different modules
Hi I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (captured in a DAT module) to suggest the payout %. For example the DAT module is as given below (not dimensionalised) The other…
Calculation Help - Is there a function or a way to count number of child of a list member
Calculation Help - Is there a function or a way to count number of child of a list member For eg, if I have State - City Hiearchy How can I count how many city does a state have using a formula?
Auto-Hide line item based on selected list member
Hi, Is there a way I can hide line item based on the selected list member? I tried to use line item subset but no luck since I have a date format and boolean in my line item. See attached picture. GLA, % of Sales and Sales Quota should be hidden when i select a different list member. Thanks, Tom
Add the current user to a field when they approve an item
I have an approval process with several gates, i have restricted to ability to approve, but all i want to do is when the approve button is pressed is apply the current user details to the Approver and add Todays date. The date part is done, as I already have the date automatically updating in all models. How can i get the…
Version subsets and selection as a format
It would be great if you could select Versions as a format of a line item. This would make it much easier to pull data from a specific version into a module without versions, for example using a lookup within a line item. It would also be great if we could create subsets of versions in models where there are many versions,

Calculation Functions

Discussion List