Calculation Functions

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.
ANAPLAN Optimization for N users
Hi , If we have users of around 10000000 in Sales team and we are using that list (Users) in one module so how can we optimize the structure of module as if that module page is published in Dashboard then it will take time at great extent to open and to load so how can we optimize the page of dashboard so that the user…
Ability to have a line item where comments can be added from leaf to top of hierarchy
Currently as part of adjustment process. users wants to make adjustments at various levels of hierarchy and add a comment to tract the change. Currently we are only able to add commentary only at leaf levels. Ability to have a line item where comments can be added from leaf to top of hierarchy
Break back a line item using weightage from another line item
current break back prorates the data based on data in same line item, but was strong need to distribute it based on a different line items data weightage.
Deriving the month/quarter value from the line item
Hi I have a line item ' Transaction Date' formatted to 'Date' . Sample value : 01-08-2021. I am trying to derive the Month,Quarter and Year from this Date value in the below sample format. Month: Jan 21 Quarter :FYQ1 FY21 Year:FY21 Is there any formulas to derive these values? Thanks Prabakaran
How to delete duplicated employee records due to movement
Hi, I have a scenario where we have created gap process to hire new resources, essentially adding new lines in our employee list. However one problem coming up is sometimes we created a gap and then an existing/internal team member applied and got the job. Not sure if there is a way we can somehow delete the original…
AgentsASA formula
When working with some of our Call Centre customers, I'm seeing use of AgentsASA being used, whilst we have the Agents formula it would be good to have the AgentsASA as a formula to use. The definition of the formula is not too dissimilar to the Agents as it uses ASA rather than SLA. I've attached the Agents and AgentsASA…
INV02 - Safety Stock Flag Count line item formula - Level2
I need some pointers to tell me what went wrong. 1) i created SYS08 SKU Details a column Country made in-----PARENT(Supplied By) 2) In INV02 i used the formula---- 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS08 SKU Details'.Country Made In] but i came out the error below. I have P3 aggregated to P1 in…
Level Model 1 Builder 9.2.5 Formula Error
Hi - I am still getting an error after trying to put a space after "Unit Price% ". Can someone help to see what might be wrong?
Change NAME() and add CODE() to Users list
As a Model Builder, I need a function to return User's First & Last Name, so I think the best solution would be adding CODE() function for Users list (which would have current functionality of NAME()), and change behavior of NAME() function applied to Users list. For backward compatibility, if NAME() cannot be changed,…
Formula Summary Method for Formula Scope set to Actuals Only
Hello All, I am having trouble getting my summary method to work correctly. I have a line item that is set to formula scope 'Actual Version'(this cannot change), but I would like to use the summary method 'Formula'. Currently when trying to use the summary method formula I get the following error message "invalid…
Deriving the current Month
Hi We are using the line item 'Month' in one of the module, and the objective is to derive the current month so that we can capture the purchase trend of our hardwares.When I try to use the formula as Month= ITEM(Time), I am getting the error message as shown in the screenshot. I have also attached the settings of…
Plan looping activities in time
Hello everyone, I'm trying to build a solution I have not yet encountered before. The assignment is to plan a "chain of activities" and the amount of hours they cost over time. Each activity is triggered by another activity, but can also be triggered by itself (let's say that the activity needs to occur every year). One…
SUM function from a list with text formatted line item
How to create a SUM formula from a list but the format of the line item on the list is text and how to automate upload data from SQL server into Anaplan thank you @josephine_surja
Sys: Time Module Formula
Trying to understand what is wrong with this formula and why it doesn't give me 2019-2022. Instead, I only get 3 years, 2020-2022. If I change the formula to Prior Year -2 I get 2021-2022. Would appreciate any ideas.
REP02 SIZE MARGIN REPORT- Revenue & Cost of Sales
REP02 SIZE MARGIN REPORT- Revenue & Cost of SalesHI Team The values for Revenue & Cost of sales are not appearing in the REP02 Size Margin Report. Have attached the Screenshot for your review.. can you help clarify

Calculation Functions

Discussion List