-
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, " ")
-
L1 - Exercise 6.8.6
I am working on L1 Model Building training and I am on exercise 6.8.6. It says "In your model, open the SYS04 Location Details System module in Blueprint view. Add the formulas to the line items:" Line Item Formula CodeCODE(ITEM('G3 Location'))CountryPARENT(ITEM('G3 Location'))RegionPARENT(Country) The desired outcome…
-
Lesson 6
I am stuck here, it keeps saying the formula is invalid. Need some help!!!
-
Boolean, lookup and lists
I am stuck - I have a Boolean that I want to populate based off the value in a given list. If this was excel I would write the formula as If Pay type = H then True else false. But I know that I can't do that. So I moved on to thinking I need to use the lookup function, but I am at a loss on the syntax to ensure it is a…
-
Level 1 Lesson 6.6.3
Hello, I am not understanding why I don't have a date showing in the current period start row and why I don't have a check in the actual period row as well but in the forecast period and forecast months only instead. Any help is appreciated.
-
Driver Calc help with logic
I have a driver called "set to plan" which is just assigning the planned amounts to the forecast periods, but this is only happening for 2022 forecast periods. The previous driver Calc: IF Driver Method <> 'SYS002 - Model Lookups'.Set to PlanTHEN 0ELSE 'REP001 - Balance Sheet (Reporting Output)'.Amount[LOOKUP: 'SYS006 -…
-
3.5.4.2 Create Distribution Center Capacity Module
Hi, I am having trouble getting the Total Beginning Inventory to map correctly. I am using the formula: 'INV01 Inventory Ordering'.Beginning Inventory [SUM: 'SYS08 SKU Details'.Supplied By]. I get the following error: "Datatype mapping used for aggregation doesn't match any dimension of the result" I'm not sure how to map…
-
Sum over a specific periode
I need to sum values inputed in months into a line item independent from time over a specific time period already determined by start and end date how can i do that please ???
-
Previous Year to Date Calculation
Hi everyone, I am in need of a formula for specific line items from our P&L that calculates the previous year's YTD values. For example our YTD currently shows Jan 22 - May 22. Ideally I could have a separate model to choose each line item and show the YTD for Jan 21 - May 21. Is this possible?
-
Add a dependent to the listings with Top Level.
hi! I want to add a dependent to the listings with Top Level. I would like to prevent TopLevel from being selected in the pull-down. How to do it？ Please help me.