Calculation Functions

FIRSTOCCURANCE should happen based on High number
Hi All, Is it possible to get FIRSTOCCURANCE based on Highest Number? As per the below Example: 1. "PRODUCT A" has the Highest Transaction number- 4,000 in the second Hierarchy(Bucket 2). "PRODUCT A" Will TRUE Under BUCKET 2 Parent. 2. "PRODUCT C" has the Highest Transaction number- 3,000 in the first Hierarchy(Bucket 1).…
Stagging List
Hi Team, Please help me with the below requirement, I am using two list items 1. Product List (Stagging List with Hierarchy) Ex: 2) Key Products(Flat List) Ex: Having only one Product: PRODUCT A In the Product Hierarchy list, I am maintaining one attribute called Key Product ? with the boolean format. Now, in Product…
TIMESUM cant aggregate(e.g. MAX) time period on time period dimension?
Dear All, According to Anapedia, "Line item to aggregate The value to aggregate over time. The Line item to aggregate argument can be a line item of any format." But, when I try to aggregate time period line item as follows, it returns an error. Example Timesum Date = TIMESUM(Date, TIME.'Mar 18', TIME.'Jun 18', MAX)…
Filter Full Year
i want to ask, i have module like this the module have 2 lines item actual and budget for the display i used filter for this, but the problems is in the full year the line item is actual, i want to change to bottom up amount, so if on the FY 21 have actual and bottom up amount FY is Bottom up amount and if FY 21 is actual…
REV03 Margin Calculation
Hello, How can I please, desincrement my (Renenues-Cost of sales and margin ) I just wanted to test this , unfurnately, everything is changed. Hello, how can I desincrement this?
Enhancement to RANK function when dealing with tied rankings
It would be really useful for certain cases if the RANK function could generate a sequential output when dealing with tied data. Currently, the RANK function can deal with tied entries in 4 ways, MAXIMUM, MINIMUM, AVERAGE and SEQUENTIAL and all handle tied data in a slightly different way but do not generate an output in…
MAKELINK Embedding Issue
Hello, I am trying to embed a MAKELINK formula within a list, however the list item I want to embed the MAKELINK into is a function of a LOOKUP, and therefore I am struggling with how to format the MAKELINK. See below: The current List Item title is "Item Name." The current formula for "Item Name" within the list…
Collect () function with multiple/varying formats
The Collect() function is great for collecting values, however; becomes problematic when trying to bring in a combination of numbers and percentages, and impossible when trying to bring in text or list items. It would be great if the collect formula could follow the same formatting as the source module (i.e. no need to set…
Additional Argument for TimeSum
I would like Anaplan to add a new optional parameters for Timesum. The formula would look like this, TIMESUM(x, [f] , [t], [a], [at], [ar]) wherein * [at] stands for aggregation type (simple, year on year). If omitted, default to simple * [ar] is the resulting value in absolute amount or percentage growth. If omitted,…
How to count in which number a particular date will come
Hi all, I have a module in which a line item is date formatted and need to find in which week the dates will come as i have to calculate weekly average for all the weeks of a year. Please suggest how to achieve this. Thanks
'SYS08 Employee Details'.Region
I'm having a little difficulty in the exam on activity 6. I understand the sum that needs to be completed on region and role, however I am having difficulty updating the region on the SYS08. Am I going down the wrong path or how should I think about updating this region in the module? Thanks,
Taking an average of specific Quarters, like all Q1 or all Q2 over many years
Hi, I'm attempting to generate some historical trends to drive future projections. In doing so, I have % Weekly over a 13-week period (one quarter), and I have this over many quarters. I'm trying to capture an average of all Q1 % weekly values (such as FY18 Q1, FY19 Q1, FY20 Q1, etc.), to predict a likely quarter…
User filters and Top levels
Hi, I want to set up user filtering for a module, with Customer and sub-brand, I have a user filter module, and system module with the appropriate line items I use the system module as a filter and this all works as expected. I want to be able to choose a specific customer and a specific brand or a specific customer…
Logic Line item availble two function (Input and Formula)
Hi, Everyone. I have a question about logic Anaplan, I have a module that will create an item that can contain input and formulas, for example, for example, a period that is less than the period parameter will be blue font or input by the user and more than the period parameter will take a logic formula. Has there been a…
SET CHECKBOX value through a given condition
Hi Everyone! There is a way to set one line item boolean to TRUE to specific condition and make it editable for other condition ? On the example below, "Main process" is checked i need to check the "Process Comp" on the same line and make the above enabled to edition (check/uncheck), is it possible ? I'm trying to set…
Count Function
Hi, How could I count days by 1) weekday type and 2) Actual data or not. Ideal result would show X day for "Weekend" for Actual data, Y day for "Holiday" for Forecast data.. etc. * Index is a "Day" list from 1 to 31. * Column "Weekday" and "Actual data" are manual input. * "Value" is a supporting column. Feel free to…
Is there a way to hide zero value line items?
Hi All, Can someone help me how to hide zero-value line items in a model or dashboard (within the dimensions). regards Sudhir
Forecast Data using TIMESUM function
Hi Team, I have one situation, where I am calculating a Line-item in Forecast scenario using Sum of Last 12 months (from the Current Period). Need your inputs to help with the below model design. Scenario 1: Current period = Jan 2021 Actual Version = Jan 2020 till Dec 2020 Forecast Version = Jan 2021 till Dec 2021 (i.e.…
DCA based off of a user in a module
Hi all, Wondering if anyone knows of a way to matchup the user from a module with the user list used in the DCA module. Obviously you cannot lookup based off the user list, so wondering if anyone has a workaround.
Finding the next non blank field
Hi, This must be simple but it is driving me mad What formula do i need in the Next Non Blank line item to find the next non blank date? Thanks
Formula using Min Function
Hi, I'm trying to replicate this Excel Function in Anaplan. I want to make sure my Anaplan Function is picking up all the values for my Line Item from the begging through the end of the month, and not just the beginning and end month numbers. I have the Formulas below. Please advise. Excel Function…
Confused on how to use Min Function
Hi, I' trying to use a Min function to take the min Account Balance in a month. This is the function I thought of using but it is not working. Both are formatted as Numbers. 'Y02 Accounts'.'Closing Balance (01)'[MIN:'S01 Time Settings'.Day # of the Month] Thank you
Quarter value as numeric numbers
Hi All, Required a quick help in getting the quarter number as numeric format. For example in attached screenshot, need to get the value for second line item as entered. All Q1 Months should populate with numeric number 1, all Q2 should be populated with number 2 and so on.... Quartertodate() function gives a numeric…
Boolean between two dates
Hi, I have a module with three line items: "From", "To" and "Any", which are all Boolean formatted. I also have time as a dimension. "From" is just true for one month, which comes from another module, and the same goes for "To". My problem is within the "Any". I want that to be true for all dates between the "From" and…
Need support with Time Management using DCA
Can anyone help me what's the best way to identify - Current Year Current Quarter, Current Year Previous Quarter, Previous Year Current Quarter using DCA and Boolean.
Ability to reference a Line Item generically.
I am requesting the ability to use a generic 'me/myself/self/here' reference in functions that require a Line Item. An example: Original: PREVIOUS(Total Average Balance) + MOVINGSUM(Total Average Balance, -11, -10, AVERAGE) New: PREVIOUS(Here) + MOVINGSUM(Here, -11, -10, AVERAGE) The benefit of this is: if the Planner…
End of Month Totals in a Module.
How do I get end of Month Totals to show in a Module that is has a daily time dimension?
Circular Reference with CUMULATE
Hi All, I am trying to solve an excel model in Anaplan where my current value is a calculation of the cumulative of previous values. The calculation works fine in excel but I am unable to break this down in Anaplan. I am adding the screenshot for the logic of this model below. Any help or suggestions would be helpful.
How to make Line Items into inputs?
Hi, I'm not sure how to make my Line Items into inputs(blue). They do not have formulas in them so not sure why they are not allowing me to make them inputs. Please advise. Thank you Pic attached
Call Center Functions: Agents must return whole number?
Is there any equivalent or trick to returning 'fractionalagents'? AGENTS(w, t, y, z) will always return a whole number. My stakeholders are interested in both whole/fractional agent calculations.

Calculation Functions

Discussion List