
Calculation Functions
Calculation Functions
Discussion List
- Hello, Question - I have a module to calculate the percentage correct (e.g. 75%) and I want to be able to rank this on a scale of first to tenth place. Advice on how to do that? I tried using the RANK…
- Hi, Is it possible in Anaplan to display the codes of both Child and parent in a single line item. I have requirement to show the code of both in the same line item. If its Boolean then Any or All sum…
- Hi, I have created the two boolean value but I am having problem while creating Beginning Inventory. So can anyone please help me with the correct formula and data.
- Hello, I'm stuck on a formula that seems obvious to me. I would like to retrieve the time period of a line item : Week : list formated. time period by week : format time period, applies to week => i w…
- Hi, I am having problem in Level 2 Sprint 2 - DEM03 Demand Forecast Module in creating a saved view as I am not getting what they are saying to do. So can anyone please help me with the correct formul…
- Hi, I am having problem in Level 2 Sprint 2 - DEM03 Demand Forecast Module as I am not getting proper data so it's a request can anyone help me with changes as Override Forecast should have value as 6…
- Hi Anaplan experts, Maybe you can help me with my issue? I am building a module that requires to show the current quarter (CQ) as a YTD value without summing up as FY. It means that if selection is Q1…
- Hi all I have a source module with dimension list A and an output module with list B. To bridge this, I have a simple third module where the end-user can input the mapping between A & B. This works pe…
- Hi Members, I have an requirement of identifying unique values of customer in each department. Please see below module which is have a dimension of departments list with three list items(D1,D,2,D3) an…
- I dont seem to understand what am i doing wrong in this Please HELP!!
- I need some help breaking down data that has been inserted into Anaplan via the excel add in, so that each component in the existing module can be listed as individual line items as in a data list. Th…
- Here's the situation: I have a module with two Boolean line items that should act as the inverse of each other. As an end user, I should not be able to click both boxes. Screenshot below Basically, If…
- Hi all, I'm a new Anaplan user and have a question regarding the FINDITEM function. I have currently have two numbered lists (1. Account List & 2. Raw Data List) and I would like to use the FINDITEM f…
- Hi, I need to get total of selected roles occurrence which can fall in three different categories. For example, among all the users , I need to count how many users have role of ADM, and then if they …
- Hi All, Just want to clarify if I can use FIND function to identify a special character. So I want to check if the string contain "@" ; the logic I am applying is: Line item 2 = FIND("@xxx.com", Line …
- hi team i m trying to add code text by using CODE(ITEM('G2 Country')) but in toggle mode, it not show code
- Hi, I would like to only show quarters and the full year value (not half year values) for the current year. How do you create a time filter to only tick the quarters and year in the current year but n…
- Hi Team, Is there a way to count a redundant words in a text line items? for example, I want to count the word "Anaplan" in a nested text line item that contains: "Anaplan is a cloud based tool. Anapl…
- Hi, I have 48 months of historical data in my Personal Project and need to forecast for the next 12 months. I believe that Anaplan has AI feature. How can I achieve to forecast by using that feature i…
- I really miss the possibility to select Working days as a timescale not only days. I would like to have the possibility to use all of the "time formulas" that is only to be used when you have a timesc…
- Hello all, I have a tricky point, and cannot succed to solve it. There is Confirmed orders (already sold) and Forecast orders (we produce in advance because we think we need to have some stock for man…
- I am currently working on the Level 2 Sprint 2 2.3.10 Activity: Create Demand Forecast. In this activity, I need to create a formula which takes weekly growth rates by Product Family in one module and…
- Hi, I have requirement in which I need the Total Cash value - which is kind of top level but the top level is not defined in the list configuration so I have tried my best to get the Total cash value …
- Hi, For a client we have a setup where we need to plan and report on multiple UOM (liters and units). Currently we're looking into setting this up as following: * Client needs to decide per SKU on a '…
- Hi All, I am facing an issue in the calculation of percentages at summary level.I have a module where I have a percentage calculation field where the percentages are calculated and are imported to ano…
- Hi All, I am facing a challenge while replicating the Actual selection to Forecast. Can we have a formula where forecast will take the same Boolean selection as actual. In the Column are versions(Not …
- I have the following line items- A,B,C. I need to create a new line item D which should take previous quarter values if C=0. PFA screenshot.
- in Learning Activity Sprint 3, we asked to make a Distribution Center Summary UX Page and when I take the exam, there's a question that I wont be able to answer cause it doesn't match the values on th…
- Hello Team, 1. We have a model where all the invoice amount is multiplied by six after the latest data is uploaded. 2. Also, I am not sure where the source data is coming from, which I need help with …
- Hi I'm trying to get the last quarter of the FY formula. I have Q1FY22, Q2FY22, Q3FY22, Q4FY22. I need a boolean which checks the last quarter of the FY ie., Q4FY22. Please help.