Calculation Functions

Further help, with what should be a simple lookup
Hi, I have a ranking module as below This shows the top customers and some data changes ranked, also there is an image for each customer Now I have a module where I need to store the top 5 customers images to feed a business report A simple lookup in Excel, looking up 1 ,2,3,4,5 etc but for the life of me i can't figure…
Fetching Start Month and End Month for a given Quarter
Hi all, I'm trying to fetch Start Month of a Quarter input by the User. I created a line item for input by the user formatted as Time Period Quarter and another Line item formatted as Month. I tried multiple ways and looking for help to fetch Start Month (say for selection of Q1 FY20 - looking to fetch JAN 20 similarly for…
Rank using Unique Item
Hi, I have a module which shows change in volumes by Customer - Product (over 5000 lines) I then rank these changes largest to smallest, and have a view of that. Customer ProductLast MonthCurrent MonthChangeRankCustomer A - Product 1340,480311,576-28,9051Customer A - Product 270,32646,326-24,0002Customer D - Product…
Level 2 - Sprint 3 - 3.3.5.2
Let me know, if what I did is right or not Create a Filter You will need to create two Boolean-formatted line items in the SYS01 Time Settings by Week systems module: * Line Item Name: First Week of Timescale? * Use this Boolean-formatted line item to select the first week of the timescale. * End users can manually select…
Level 2 - Sprint 3 - 3.3.5.2
Can I get help regarding this? This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week. The syntax of the formula should be written: If it is not the first week of the year, then use…
Weekly subtotals for model with calendar type M/Q/Y
Hi, colleagues! Do you know any elegant solution for entering weekly subtotals or week ID's into module of model with calendar type month/quarter/year? Cause I faced such issue: FP&A team wants a module for calculating daily sales plan - that's ok, but another step of the process is review of that plan by BU owners who…
NPV Function cannot get what has been provided in the technical document
Hi all, I tried to replicate the example in the Anapedia link However, I cannot get the same result as in the example as below. My module as below, my result as highlighted. Even the same cash flow data, same date column, and same formula with hardcoded discount rate. What do I miss? any idea? Thanks.
Why does the formula change when we change the Time Range from CY and PY to Last 5 yrs?
Why does the formula change when we change the Time Range from CY and PY to Last 5 yrs?
Community perspective: RANK and row counts – Management Reporting with multiple lists
A common request within any planning project is to create well-formatted, standard reports for the business to consume. However, these aren’t always as simple to create as first thought. The Management Reporting capabilities within Anaplan produce great looking outputs. However, they require a fixed number of rows for each…
Level 2 3.3.6 Confirmed Purchase Order Receipt shows no value???
I can't get the value or in others words add the numbers in the Suggested order amount of the month. The line item always shows 0 no matter how hard I try. You can see my formula on the formula bar. Where do you think I have done wrong?
Boolean value from a Time Dimensioned to non-time dimensioned module
Hi Team I want to pull a Boolean value from a time dimensioned module to a non time dimensioned module. Source module looks something like Could you please suggest? Thanks
Search if a list member exists in a text line item
Hello! I got a Invoices Data Load Module that gets its data from a numbered list "Invoices". The line items (invoice number, client, comment, amount, date etc) are the "Invoices" list properties. We started selling a new product last month, but our ERP doesn't fill the "client" field in the invoice when it has that product…
L3 TAR01 Module and it's check Module
Having trouble seeing why my check is not coming through for my TAR01 module. Attached are screenshots. Thank you
RANKCUMULATE function not working with a negative number
I have a RANKCUMULATE function that is working fine but when a negative number is referenced it ignores it rather than subtracting it from the running total. I am hoping someone has run into this before and has a solution for me.
Uniques Identifier as code for a Numbered List
Can i Use Numbered list Unique identifier as a Part of code for Numbered List?, How long can a Unique Identifier can go? I have a numbered list Named 'Activity List' under a Customer List as its parent and I am Planning to use Unique identifer as a code for that List as Name(Item(Activity…
Line Item Override Amount-Write?
Hi, I get the results I want in my Model with the following formula, but in the Exam it is not accepting my formula. Is my Syntax incorrect? IF 'INV01 Inventory Ordering'.Submit Purchase Order Request AND 'INV01 Inventory Ordering'.Override Amount <> 0 THEN TRUE ELSE FALSE Thank you
User Story 1.6 L3
Hi, I can not get my module to populate. Please advise. Thank you
Identify records with same value in Column 1 but different value in Column 2
Hi Team I need to identify records that have same value in Column 1 but different values in Column 2. For eg, from the below data set, I want to identify the 1st 2 records may be by adding another line item NameCodeTimelineRoger F1MonthRoger Federer1QuarterRafael N2MonthRafael Nadal2Month Thanks
Time Filtering
Hey all, I'm wanting to update a time filter to use in module views but am having a hard time figuring out how to create a specific condition. I want to have a filter for the current quarter and the previous five quarters as well (so 6 quarters total). Right now I have a line item that gives each quarter a decimal value…
Cycle Shift Input Design
Hi Everyone, I am trying to design a module for shift input. It should be working in this way. When we enter shift start time and cycle period, that start time will repeat according to cycle period until we override it. I am struggling to design and figure out formulas? Any idea and tips are appreciated. Thank you.
L3 TAR01 Module
Hi, My TAR01 Detailed Sales Target is off. I'm not sure why. I tried to pull from D02 Data Module, but then my dimensions were wrong and wouldn't let me look up by product and country. I have been stuck on this one for a while. Please advise. Thank you
Community perspective: IFO – UPPER and LOWER to the rescue
IFO is a very crucial formula to use when working with raw data, staged in Data Hub, to create lists from within the data's metadata. It truncates the metadata within its line item to "Its First Occurrence" to prevent duplicates being imported into its target list. This keeps the action results clean and optimizes…
Filtered Summary View based on the presence of a list member
Hello, I'm stuck on the logic to create a filtered summary view. I have a table A, but now want to create a filtered table B (which is a list of only the cost centers & Worker Type combination with a Large Group Size (i.e. Headcount total of 21 & above across all Work Groups.) So in the image below: The summary view (table…
Scenario for calculation
Is there any formula instead of first occurance
Forecast range in Statistical forecast APP
Hi, I want to use Statistical forecast APP. This app presupposes forecast 1 Month? Some Forecast method only forecast 1 month like Winter's method. I want to forecast 1 year. Is there any setting to change forecast range? or I shouldn't use this method?
TAR01 Detailed Sales Target module
In the description from '5.2 Model Build Specifications', we need to calculate the proportion of a country's total sales revenue by product family each account's product sales contributed. The TAR01 was created already in the model, it's dimentioned "A2 Account>Product#' only. However the first line item is to calculate PY…
Confused about Lag, Lead, Post, Offset
I got confused between these functions. It's unclear for me now. If any one can help me with simplifying this it would be very helpful for me. Is there use cases where Lag and Lead should be used instead of offset or post? Thanks in advance.
Rep Count from Start date to End date (if applicable)
Hi All, We currently have a "Positions" module that is not time based. We show our current salaries, job titles, etc. that comes from our payroll data here. This "Positions" module also contains the Employee Start Date & the Termination Date (if applicable). I have created a line item that counts the amount of "Job Titles…
Problem aggregating values from timscale day to month
Hi all, I have problems aggregating values from a module dimensioned with day, to a module dimensioned with month. I am doing rent calculations in a module by DAY time scale. When I try to aggregate this to a monthly calc module it does not work. No values are pulled over. It is the last part of the formula below that does…
Getting data from a module with no time dimension to a module with time dimension
My source module has no time dimension but with month list, and period in line item. My target module has a time dimension Month Period, (ex. Jan 19, Feb 19, etc) How can I get the data from My source module?

Calculation Functions

Discussion List