
Calculation Functions
Calculation Functions
Discussion List
- Can anyone please share screenshot of this list. I am trying to upload CYW file, but its not working. Please advise. Thanks -Pooja
- 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 …
- 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 res…
- I am not getting any reference on how to assign accounts to territory. Can anyone please give any hints.
- 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 …
- 'SYS06 Territory Account Details'.Count[SUM: Account Name] Can someone help me understand what am I missing here? Thanks
- 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 th…
- 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 a…
- 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 p…
- What are the tools we may use to test anaplan ?
- 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 a…
- 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 calculation…
- 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.
- 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…
- 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?
- 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 dat…
- 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 …
- 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 (capture…
- 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?
- 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…
- 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…
- 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 looku…
- Hi, I have 2 different list (L3 and L6) I have 2 module, 1st module has L3 list is used and 2nd module with L6 list is used. User able to enter data in 1st module (L3 list) and data should be copied i…
- I am currently importing data with a concatenation of 3 General Ledger identifiers and a customer code. A sample would look like LE10000.LMF10000.1000000 for the first GL indentifiers. Everything is c…
- I am looking for some more background on the differences between these two functions. I understand that AGENTS takes into account the SLA and target response time, but where my confusion lies is mores…
- Hello, I am trying to count how many items are in a list and display it in a module? In the example below we have 3 items in the list. Does a function like this exist?
- It would be useful to have more shortcuts when entering data in the UX. At the moment we can enter e. g. 1e3 to input 1000 in a cell which is great and makes it easier to enter high values. In additio…
- It would be extremely helpful from an end-user and a workflow perspective to have the ability to capture the timestamp of a manual input as a separate line item, instead of having to look through mode…
- Hi all, I am having an issue using the PREVIOUS function. In this project I have a timeline split in quarters, semesters and years, thus I should be able to see the values from the previous quarter, s…
- Hi All, I am unsure where I might use TEXTLIST function. There has never been a need for me to use this but I would like to understand where, when and how this might be useful. Your insights are much …