Calculation Functions

Mapping Module no time dimension to time
Hello, I have a csv import that is not dimensioned by time and date in the same cell. It can not be changed for a monthly process import. I am 90% of the way there. I created an import module (not dimensioned by time) and a reporting module that is dimensioned by time. I am able to pull in the data to the reporting module…
Formula error when trying to remove 'Use Switchover'
I have a group of calculated line items that I want to remove the 'Use Switchover' functionality from so they don't pull in Actuals data. However, when I try to untick the box in blueprint mode, I get an error message saying that the formula is invalid. Would be helpful to understand the connection between formula and 'Use…
Is Summary not dynamic?
Hi, I have explained everything in the below screenprint. Please share your views on how to handle this case.. Note: The module is data module where all the data is imported through csv file.
How to calculate within the list items to get the maximun of the items from the first to current?
Hi everybody! Need help to do the calcution within the list. Here is a list with items(#1,#2,#3,...), and properties of Input and Output. The Output is supposed to be the maximun value of the input from #1 to the current item as below table. Anyone has solutions about this? I found it difficult to calculate list…
Line Item Subsets and Summaries
I'm running into a curious situation where I'm trying to use the Summary of a module that includes a Line Item Subset downstream in another module. I'll walk through the situation below. I built a single module to drive my line item subset, and I created a "top level" or summary item: I created a line item subset that…
calculation
Hi experts I have use a list for time dim. and i considered four week in every month . i just want that in first 3 week there is the 7 days in the week and in 4th week there should be rest of day in that particular month . i cant get how we can do this when we used time dim. as a list . suggest me that process I have also…
Modeling advice: How to build item level discounts for set time periods
Looking for help and advice on how to build out a discount function in our model. My company manufactures products and sells them to stores, for this example let's say our customers are Target and Walmart. Our business will give special discounts on specific items (~10 items) for specific time periods, like May 2nd through…
Option to **** Formula Error Toasting
Most of the modelers know what is wrong with their formula, the moment they press enter and it starts toating system. There should be an option to **** the error processing in case of formula errors.
How to do Excel Search in Anaplan
Hi Anaplanners Has anyone built an Excel Search function equivalent in Anaplan? What I would like to replicate is: 1. Client has a text mapping table (screenshot 1) which maps Strings in Column B to their expense classification (Column C & D) 2. SAP extraction which contains a column called Text (screenshot 2) , Column H.…
Count the number of users using User list for every months.
Hi All, I would like to take a count of the users using the list Users for every month. I have a module with: Row: Users List Column: Time(Month) Line item : Number(whose formula is 1) I need to sum the number all all the users for a particular month for eg for Jan sum of users can be 74.
How to ramp up to understanding an Anaplan ecosystem
Hi All, What are best practices / tips to ramp up to an Anaplan ecosystem. I received my Model builder certificate and have a good grasp of the system terminology. I recently was brought on in the middle of an Anaplan project and having difficulty ramping up to what all the build activities that are happening are. My…
Avoiding a Circular Reference when pulling the previous day from the same LI
Hi, I'm trying to find a way to pull for the previous day, while skipping over weekends and holiday's, for the same LI. Below is an example of the formula I'm trying to do, but I get a circular reference. This formula works if the LI is from a different module, but I need to be able to pull the previous day for the same LI…
Using a subset vs boolean
Hi Everyone, I was wondering if it was possible to have the box to select a subset for list to be shown in the UX? For example I have 2 subsets, CAPEX, and EPMO, among the project request list (where project planners can request projects for the budget cycle) and want them to be able to select if it is a CAPEX or EPMO…
Formula Help: Apply Rev. to Earliest Date
Hi, I need to create some logic where revenue that is allocated to a parent, is all placed onto the child with the earliest date associated with it.
how to rexecute this correction
Hi Community, Below is the screenshot of the column Revenue Actual CY. As you can see the Net Operating Expense (income) line has a value of 285,480,176. It is the sum of Corp Service Income until Quality Mngt. How can I make the value of Net Operating Expense (Income) the same as the children 71,370,044. I tried replacing…
FINDITEM multiple columns
Hello All, I was wondering if there is a way we can use FINDITEM to find a value from multiple columns. The way FINDITEM works is by comparing a list with a specific line item (column). However, in this case, I need to be able to find an item that may be in column 1 or column 2 or 3. Is there a way to achieve this? Any…
How to SUM using a dummy list
What is it? This article explains how to SUM, SUMIF, and use other aggregation methods using a dummy list rather than Anaplan’s native summary functionality. Why is it useful? Anaplan's native summary logic is simple to use, elegant, and effective. However, sometimes it results in bloated modules that use up workspace…
Drilldown highlights relevant logic string
When a user uses the drilldown feature it would be awesome if the platform highlighted the particular logic string that was being applied within the formula to determine the final result. This would be helpful to parse long, complex formulas with many possible results. For instance, sometimes formulas have many IF a THEN b…
Disaggregation
Hi Experts I want to Learn About Disaggregation can You Please Guide From Where I can Learn . Thanks In Advance .
How to link a property/line item on modules with different dimension
Hi, I need to get data from a line item from one module with a different dimension with my target module, I cannot do a lookup because the 2 dimensions are not totally related. See details below ; I need to get the Position value from the source to the target, as you can see in the target module, not all Position list is…
Simplifying a formula with multiple checks for User Input
Hi, I have a grid in which there are multiple line items (approx. 25). These line items are user inputs and when the user enters these either manually or through file upload, he sees a validation message that checks his input related to multiple conditions (e.g. Invalid Date, Mandatory Field Blank, Duplicate Entry etc.) .…
Calculate Cashflow on the basis of IRR set by the user
In Excel we have Goal Seek function to set Target value of a calculated cell and based on that target value, excel performs reverse calculations and gives source value needed to achieve the target. Now, in Anaplan I want to achieve this similar functionality. IRR is an Anaplan function resulting in value calculated from…
Formula and Ability to Edit
Hello, is it possible to have a formula that is formulated for a certain version or from an IF, but then allows you to hard code if that is not true? For example if we were to say "IF ISACTUALVERSION() THEN 0 ELSE {Ability to hardcode here}" Thanks in advance
3.4.4 Activity: Create Stock Exceptions Review UX Page
As per instructions, UX page for stock exception review, time period are monthly , half yearly and yearly. Where my time drop down shows the weeks too. Is it not managed well till now? Regards
formula revision for QTR last year
Hi Community, I would like to ask advice on formula revision of my clients report. Below is the target module. The column of last year is where we are encountering a problem. Requirement: it is supposed to pick up the value from the source module but the total QTR of last year. Target module: OUT007 In the target module if…
3.3.12 Activity: Create Product Replenishment UX Page
A quick suggestion please , we have created a INV01 Inventory Ordering module and chart for UX as well but my quick feeling is none of them matches with view in terms of line items and sequencing of line items. We can simply ignore it ?
is there a way to forecast expenses by vendors?
I'm trying to forecast the details by department's with their vendors, like for example Anaplan as a license vendor I want to forecast by that line of expense as part of the Technology department that eventually will roll up to the Software expense P&L as part of the total company. Not sure if I need a list for Vendors and…
L2 Sprint 3 INV01 Shipping Time Weeks
Hi, It shows just zero in Shipping Time Weeks line of my INV01 Modules although the formula is correct. On the other hand, TRA01 Shipping Metrics by Week do not have data yet. I don't know where I am doing wrong. Here is my screenshot with the formula for Shipping Time Weeks line : Expexted: All helping efforts are…
Formula Help
Hi, Need help creating a formula that will look at LI for a rolling 5 day forecast and return back the max number of those 5 days. I set up a systems module that looks at the forecast for 5 days, and then tried to use it in the formula below.
Detect CRLF character in a text line item
I have to replace CRLF (carriage return / line feed) characteres form a text line item. How can I use the FIND function or more better the SUBSTITUE function to replace such a CRLF char. Result = SUBSTITUE(line item to replace, CRLF character, " ")

Calculation Functions

Discussion List