-
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.
-
Lookup function help
Hi.... I need some support in creating a formula to for a look up I have created a mapping module where: 00.nondefault is a list Stage 1/2/3 is a list Y/N is a list Line item is boolean I need to map it to another module so that in the Anaplan classification it identify whether it is stage 1/2/3- not sold etc. I have…
-
Calculation of Payment Frequecy
Hi All, I've one use case where I've to calculated payment according to payment frequency i.e monthly, annually and quarterly. I've system module dimensioned by lease where user enters lease start date, end date and payment frequency. For e.g. Sr. No Start date End Date Payment frequency Lease1 4th-May-2012 12th-july-2022…
-
Getting zeros when using the LOOKUP function
Hi! I am getting zeros in my data when I am using the LOOKUP function. What are the possible reasons for this? I am sure that I am using the function correct. The function works but the data only shows zeros.
-
Lookup based on a boolean line item
Hi, I have a target module INP01 with 5 dimensions (P1, C5, Size&BPC, Time, and Deal Levels) and I need to bring values from another module DAT05 which has 4 dimensions (P1, C3, Size&BPC and Time) The point is that it needs to be done based on a boolean line item selected month? in DAT05 (which is true for the month…
-
Identifying list members with booleans
Hi, I need to identify list members using a boolean. (What I tried is at the bottom) In a system module SYS06, I have a line item "P2 Product Brand" that is populated using a list (shown in photo 1), it is list formatted. Photo 1 then, I created a boolean line item that is intended to check in another module SYS03 (Photo…
-
How to sum time ranges
I have a problem when aggregating lineitem by time . I want to aggregate Amount by "Aggregate Lineitem" (From Jan-21 To Mar-21). The Module A&B has set by time range, so we can't do it. Table A ( Time Range : past 2years) ListMonthJan-21Feb-21Mar-21Apr-21May-21LineitemAmount A100200300400500 Aggregate✔✔✔ Amount…
-
LV.1 Exam Question 4
I've been stuck on this exam for too long trying to figure out where I went wrong. I thought I had the correct formulas but it is not producing the correct values to this question. For the medical cost of the Finance team, I used 'EMP03 Employee Drivers By Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department,…
-
Iferror formula
Hi, I'm trying to do a calculation similar to the IFERROR calculation in excel but I can only seem to do the IFTHEN formula in Anaplan. Does anyone have a suggestion for this? The excel function is IFERROR(X/Y, 0) Thanks, Tom
-
Question on LOOKUP Function
Hello - I have a seemingly simple ask and need help. I have a module one DAT01 with two dimensions ( Country and Year ) and a line item Annual Percent Increase and I have another module, DAT02 with three dimensions Country, Product Family and Months. I want to reference Annual Percent Increase from DAT01 into DAT02. I am…
-
Level 3
SYS 03 is already built in module and it already has formulas. These formulas not pulling any data. Please advise.
-
Territory Effective Dating
I am looking for a solution to do territory effective dating in a model that can be used year over year without creating a new model each year. The ultimate goal is to roll up quota crediting to a specific Rep based on transaction date. Example: Rep A assigned to Territory 1 = 1/1/2022 to 5/31/2022 Rep A assigned to…
-
Driver formula help
Hi, I am hoping someone can help explain / walk me through what this driver formula is doing. IF Driver Method <> 'SYS002 - Model Lookups'.'Flat to PY - 70% Owned Sales'THEN 0ELSE…