Calculation Functions

ANY for List WIthout Top Level
Hi Team, I have a list without a top level (Ramp-Up %'s which do not require to be aggregated) but I need to be able to determine if any of the intersections have a value for a Filter Boolean Is there a formula/method to return a Boolean if ANY item for a list has value in a module. This is calculated from a module without…
MONTH Formula providing unexpected results with Fiscal Year beginning in February.
In the screenshots provided above you will notice the Month Value line item have a different value for the months in FY19 than in FY18 ***Formula is MONTH(ITEM(Time)). In FY19 you will also see the value of 9 be returned for September and October and 12 returned for December and January. Can someone help me better…
Formula assistance! SUM?
Hi, Still relatively new to Anaplan, but need formula assistance. I have created an input module for users to input data for a region with list attributes of internal/external and discretionary/non discretionary. Then created a GBP conversion module: I'm now on an output module, but I can't seem to sum on the…
Adjusting a formula
Hi, I am currently working on creating a P/L where we multiply a item by a certain percentage. To get this percentage, I had to create a another module and use past actual data to arrive at the %. The issue is now In my module of calculating the % . FY19 is the percentage I need to bring over to my P/L but everything I…
Get Lastoccurrence data
Hi, Please help how can I get the last value in my module. I tried to use a rank function but can't reverse the ranking to ascending because the source value are the same amount. Thanks in advance for the help. Tom
Lookup or SUM between Modules with Different Dimensions
Hi all and thanks in advance. I just want to lookup an amount from one module to another one. However, they have different dimensions, so, I created a unique code to work as link between those Modules (it is a string type). How can I perform the Lookup or Sum using this unique code? I mean, I try lots of ways, and it is…
Include Row Labels in Modules
Similar to Include Row Labels within the export dialogue, it would be really useful if model builders could display list properties in modules. This would be useful in both the NUX and classic dashboards. Illustrating with an example: consider the list hierarchy L1 Regions, L2 Countries, L3 Cities. The L3 Cities list has a…
How to put a control on a sum of data
Hello all, I have data to provide per person over different periods (I can have intersections). I want the sum of the data per month not to exceed 1 otherwise it returns an error message to the end user. I don't know how I can make this condition on anaplan. Can anyone help me please? Soukaina,
Dimension as User ID
How to set USER ID as dimensioned in Module for making user contribution application
Returning the Date of when a contract starts
I have contracts with revenue and expenses by dates (differing start and end dates) in a module (Start date ="1", the second period ="2", so on until it ends of reached end of time periods). I'm building a dashboard which reports the start and end date of each contract, and then allows a user to input a revised start/end…
calling out previous data
Hi team, How to call out previous data from numbered list similar to previous if time bounded? Please see attached reference file. Thanks, Eia
TR02
Hi All, Need your advise. I have created the TR02 module using an unorthodox process to ensure that the final sales target matches with the initial sales target(Parent level) taking into account of Overrides & Hold. BUT, details at the country's line item level is not matching with 8.4 Check Your Build. Have I missed any…
Calculating final sales forecast
Hi, In order to calculate the final sales forecast, I have used a very unorthodox process (attached below). Now, even though the overall amount at the Account parent level is matching, however there are some mismatch with individual account line level (mismatch between my module & what is there in the Sprint 1 screenshot)…
SUM Function
Hi, Is there a way to post the sum total to a separate column for each line items. Example - I want 27,484,445 to be displayed against each line item under Total column. Is it possible?? Thanks AB
Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods
Hi! I was hoping someone could share if I am missing something in this activity: and this is what I have in my module: I am having trouble matching the rounded cells and I think it's throwing off the rest of the data. Anyone have advice on how to fix this or if I am correct because I don't understand how 59.47 rounds to…
Breakback and Hold - New UX or otherwise?
Hello, I'm looking to permanently set the Hold on a Breakback cell total so that any weekly percentages entered always total 100% and the user cannot change the total monthly cell. I've attached a video for reference . Essentially, any percentage that a user enters in the week cell should always then calculate out of 100%…
Circular Reference Issue in rank traversal
I have a problem statement where I am trying to do some allocation basis rank traversal there is fixed quantity Q= 900 which i have to distribute amongst vendors . e.g if i allocate 100 to V1 basis some logic, then I am calculating remaining quantity for allocation to other vendors V2 where I calculating remaining quantity…
Urgent--- Can we copy a model from
Can we copy a model from one workspace to another? If yes, please describe.
VLOOKUP between lists with Property as key
Hello and thank you all for your time and help. Is there a way to set up a kind of vlookup between 2 lists, using one Property as the common line between them? I have created the same special key within both lists using 2 codes, that is a property. Now, I just want to do an old fashion excel´s vlookup between those two…
How to add last year and current year
Hi I have monthly data by segment by product family. - Refer to document attached I would like to build dashboard to display last year, current year and variance column. Therefore, i build 1 module, source, last year, current year and variance line item Question:- How to input formula to grab data for FY20? How to input…
Lookup between Time Periods and Text
I'm reaching out for guidance on how to build a link between Full-Year time periods and a list-equivalent Fake Years. i.e.: FY19 = "Year One", FY20 = "Year Two", etc. Some background, I have a P&L line item "Revenue" that has a year ending balance of $100,000 in 2019 and $150,000 in 2020. These revenue amounts begin to…
Experience of implementing LINEST in anaplan
Hello colleagues. At the moment I am implementing statistical data analysis in anaplan, the analysis methodology was developed in an excel. In excel, the LINEST function was used to search for the four unknowns using the least squares method. I did not find an analogue of this function and I do not imagine how to obtain…
Lookup value
Hi, Would like to ask if I can lookup a list item which is classify as a parent list? I tried it but it does not work. I got values using lookup if the list classify as child list. Thank you. Darlene
Comparing list items (formula help)
I am trying to see if items I have in one list exist in the other. I have created a module with a boolean line item and my idea was to use the formula = IF ISNOTBLANK(FIND('IN3 Vehicle'.anacode, Total Vehicles.anacode)) THEN TRUE ELSE FALSE to find if the values exist in both list. (If it does appear in both list return…
First Year of a month identification
In my Level 2 Supply Chain Lowel Bolin model I have multiple Time Settings module. SYS00 Time Settings by Month SYS01 Time Settings By Week SYS02 Time Settings by Year SYS03 Time Settings by Half Year So, I have question regarding Weeks and Months. My SYS01 Time Settings By Week has (Jan)Week 1 FY 20 - 12/29/2019-1/4/2020…
Why this Aggregation doesn't Work
Hello Team, I am facing some error while aggregating value by period(month) in the same module which having period.it works against normal list but not against time dimention
Formula Help
Hi, I have a module with Versions list(version1, verrsion 2, Version 3 in Line items) in dimension. I want to copy Line item 1 of version 1 to Line item 2 of version 2. Please let me know how to write the formula. Also if I have 2 similar modules and I want to copy Line item 1 of version 1 from Module 1 to Line item 2 of…
How to get a count in Anaplan?
OPI #Mgr 1. OPI #Mgr2. OPI #Mgr3. OPI #Mgr4. OPI…
How to get Start Period of Time Range?
Hi experts, Is there a way to get start period of a time range in a LineItem? Regards, Inoue
Level 1 Cetification Exam
Hi How much time is alloted to complete the exam for Level 1 Certification? How many qusetions are there? Soma

Calculation Functions

Discussion List