-
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…
-
Sum over selected months
Hi team, As one of the requests from our client, we are trying to add "Sum over Selected Period" next to the sum "All Periods" The use case is, that we have a module with dimensions- 4 line items and time (month). As the data is in numerical format, the default is sum "All Periods" On the dashboard, the user can filter out…
-
Scenario Analysis/Multiple Current Versions
Hi team, I'm looking at whether I can lock down a previous Version/s within Anaplan but continue to run multiple live versions, this would normally be where we have 1 standard live version but there may be a request for a scenario analysis off this live version. The process for a FP&A model would be: - Create a Plan…
-
Mailto function
hi! I would like to be able to send emails to multiple people using the mailto function. To do this, I would like to create a function that allows me to set the company to which a user belongs in the Users section, and if the company is selected, the user who belongs to the company will be displayed in TEXT. How can I do…
-
RANKCUMULATE Tranches with a "Not to Exceed" allocation
Module contains Investment Tranches maintained as a list as well as multiple investments as a separate list (Whole Dollar). A fixed $ Credit is input in a separate module, but then should be allocated to the lowest tranches first - any excess credit is carried into the next tranche up and so on until the credit is…
-
TRA01 Shipping Metrics by Week
Hi I wanted to know whether the below mentioned formulas are right for me to move forward with level 2. attaching the screenshot for the same. shippping time(week) :- YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)') cost per 1000:- YEARVALUE('DAT02 Shipping Metrics'.'Cost per 1000 Units')
-
Level 1 Exam activity 5
Hi I am stuck on the calculation for the car costs, phone costs and medical costs'. One should say the following formula would work for the car costs: But I am getting this error: Can anyone help please?
-
List - Top Level
Hi, I have a small query on Top Level (List). As per best practice, we should try to avoid Top Level for large list. Instead, we should use Lookup for the same I'm trying to use Lookup for a formula & its still asking for Top Level. When I update Top Level, the formula works perfectly (with Lookup). Is there any alternate…
-
SPRINT 3 3.5.3 INV03 Module
Dear Community I m a bit stucked with the INV03 formula for the Stock Exception My Formula : 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Distribution Center, SUM: 'SYS08 SKU Details'.Product] but i cannot see any amount popping up here and i have some amount in INV 01 Module Do you know…
-
Looking for text in modules
Hi, I need some orientation on this: I need to look for a text in the column "P2 product Brand" (first photo) in another module (second photo) and if it is there, I need to return TRUE otherwise False this formula should populate the last column of the first photo. Both columns are formatted as lis, and they are populated…
-
Level2 Sprint 3 3.3.5.4 Update INV01 to Allow Override of Order Amount
Hi I have got struck up with the activity attached the same, below is the formula which i have done. please correct me if i am wrong. IF NOT Submit Purchase Order Request? THEN 0 ELSE IF NOT Override Suggested Order Amount? THEN Suggested Order Amount for the Month ELSE Override Amount
-
Growth Percentage Not Being Calculated
Hello All, I notice that the growth percentage is not being calculated in my model despite my being confident that the formulas are correct. Can anyone suggest why this may be happening?
-
Distribution Capacity Module -3.5.4.2
I am going around in circles with this task. I finally got to a place where I know where the numbers are pulling from into Inv04 module. I need to calculate the beginning inventory by month and distribution center. The data source time dimensions (Inv01) is in weeks and the target in Months (Inv04). Initially, I was under…
-
Time Filter - Current Period
Hello, I have a module which is NOT Time dimensioned. I have a line item named as "Year Filter" with Time scale as years and Boolean formatted, formulae with different conditions in the same module. When I apply the "Year Filter" in the saved view in the same module, I DONT see "Time: Current Period". It shows specific…
-
Convert Numbered list into text
Hi, I am having a hard time trying to convert a numbered list into a text value. I have used the NAME() Function, but as a result I get the Number assigned to the list member. Instead I would like to get the text value of the Display name. The reason why I am trying to do it this way is because I need to Concatenate the…
-
need help for practice
Hi All I want to populate "text line item" which shows string between 1st and 2nd commas of the items in the module. How can i do it. which function should i use here Thank you & regards Yash
-
Boolean to filter the tarrget module
Hi, I am not able to filter the target module by using the system module time filter.
-
Creating ISBUDGETVERSION() similar to ISACTUALVERSION()
Please consider adding ISBUDGETVERSION() function, similar to ISACTUALVERSION(). This would eliminate having to setup another module with only Versions as the list and creating a boolean flag. All followed by IF VersionsControl.Budget THEN .... ELSE...
-
How to insert member in a list in between an order using actions?
I have several lists which are needed to be updated by users. So, I have created a module with a flat list (contains numbers 1,2,3.....100) and line items with these lists names. Created saved views with one column (i.e. List named line item) and imported this column data in the list. Added a "Run import" action button so…