Calculation Functions

Filter Issue
Hi All, I have 2 modules, Module 1- Dimensions - Entity, Custom Version, Time Period, Department Line Item - A,B,C Module 2- Dimensions - Custom Version Line Items as Follows: When i apply this filter in source module (module 1) , It still shows me the estimate and budget. which i wanted to hide. (Jan 22, Feb 22 for…
Circular Reference Error While Calculating Opening Base with Custom version
Hi All. I'm facing an issue in solving the Opening Base Calculation. Please help to resolve it!!! Custom Versions - Actual, Estimate,Budget Time Period (in Months) Country List Department List GL Accounts In the below screenshot, closing base is the sum of Opening Base,Gross Activation and Churn Rate. When i try to…
When to use Lookup & Sum function
Hi all, Could you please explain when to use Lookup or SUM function, I remember there was a lesson in MB Level 1 course but I am unable to find it. I will really appreciate if someone can provide a link to the lesson or explain the difference in term of when to use them. JH
Very Confused on Level 3 TAR01 Module
Hi, I'm having alot of trouble with the LOOKUP formulas for this module. I'm trying to bring in my DAT01 Actuals into the TAR01 Module by Country and it is not working. My dimensionalities are correct and all, but I think it has something to do with my G2 List. I have been trying to figure this out for 2 days now and…
Formula for First week of Timescale.
Hi Everyone, Could someone please explain this formula in layman's language. OFFSET(1, -1, 0) = 0 Thanks JH
Grouping line item data?
Hi All, I'm new to AP and I have a question..... I have a module that has Employee, Product Line and time as the dimension. My question is how do I tell Anaplan to group by certain products only? ie. Product Line: Apple, Pears, Oranges, Fig, Lemon, Tangerines. I want to group : Apple and Pears into "Fruits" , Oranges and…
Sprint 2 Target Item Level 3
Could anyone please advise, why no data is showing here? If I remove the lookup function, still no luck.
Boolean Formula in List item
I have 3 level hierarchy Namely --- Country > State > District State and District has line items as properties namely Active in Boolean format i want to connect the two by using formula like if parent(district) = true then true else else is there any way to achieve it without using module?
How to avoid duplicate item with time (ISFirstOccurence)
Hi I want to make concatinate List. I have this table. Customer is determined by Product. Supplier is determined by Product and Time(week). Now I want to Customer-Supplier List. But in this case, I cannot identify unique key(Customer-Supplier Lineitem). So When I import to Customer-Supplier List, duplicate error has…
Tar 02 - PY Account Revenue
Hi - Not sure why data is not populating in PY Account revenue. Formula I am using is "'TAR01 Detailed Sales Targets'.PY Account Revenue[SUM: 'SYS03 Account>Product Details'.'A1 Account']" As the Dimensions for Tar01 and Tar 02 are different and I am mapping it through Sys03.
Level 3 - Read only cell error
Hi - I am not sure why below error is popping up.
Level 1 Model Building Exam Activity 5 - Stuck!
I have been stuck on this activity for the past 2 days and do not know what I am doing wrong: This is the formula I tried for Bonus: For bonus: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role’.Bonus % [LOOKUP: 'EMP03 Employee Drivers by Role’.Department, LOOKUP: 'EMP03 Employee Drivers by Role’.Role] ELSE 0 And…
P2 Product and Product Platform Level 3
P2 Product and Product Platform is not populating any data, even though I tried to create Display name and using that in Formula FINDITEM(Product Flat, Display Name) and the message I am getting is " Display Name is not a recognized line item or list member Please advise. I am stuck here 😞
Rank function with Time
Hi, I want to use Rank Function. I want to rank "Num" with Location-Product. I input formula into RANK Lineitem. But the Rank function doesn't run. What is the problem?
When do I use SUM vs LOOKUP?
Determining whether to use SUM or LOOKUP depends on how the mapping table is set up between the Source List (where the original data resides) and the Target List (where the formula pulling the data resides). A mapping table between the Source List and Target List can be set up in one of two places: (1) in a Module, using a…
INV01 Inventory Ordering module - Shipping Method formula issue
Getting error when i am using below formal for Shipping Method in "INV01 Inventory Ordering" module , Tried so many ways but no luck can some one help me some thing is i am missed 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS07 Distribution Center…
Convert Line Items to Time Periods
Our Finance team requested we try to recreate this view in Anaplan for them to make their plans. We are struggling with how to show both the detailed info (vendor, department, country) and the time periods (Jan 22, Feb 22 etc) as single rows in the same table. Our best workaround so far is to include the time periods as…
Chrome default setting for Google G Suite Gmail to use with email link or MailTo
If you click on an email link or MailTo link and your Gmail doesn't open up in another tab, make sure that the protocol handlers in the Chrome browser is set correctly. This is what your setting should look like: If your email is not set to default to Gmail, make sure the "Sites can ask to handle protocols" boolean is…
Formula to YEARVALUE with Actual months
Hi Guys!! Could you please help me with a topic? I have a module, where I need to calculate the average of my NET SALES for 2022, and that every month has the same value. I applied the YEARVALUE/12 formula and it works for Forecast months. However, for the current month, Anaplan brings me the Actual value and divides it by…
not a recognized line item
We are repeatedly getting the not recognized line item error when building out simple formulas sing line items all contained within the same module. In the screenshot below A-3 references A-1 + A-2 and all are clearly line items, this is happening when selecting the lines items with the formula editor and typing out the…
We'd like your feedback on the App Hub
Hi all, We are currently looking for Anaplan customers to participate in 60 minute research sessions.Sessions will take place remotely from March 2nd to March 11th. Participants will receive an e-gift card as a thank you for their time, if their company policies allow them to receive these. For this session, we will be…
Level 2 2.3.9.2 OFFSET formula
Hi i wrote this formula.It has taken without any errors but showing zeroes This is my formula IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 Can u provide correct formula
Product list formula
Hi - P2 Product list has parent. Why formula is not pulling product family here?
Use if not and sum formul
Hi, Can some one advise me how to use a if not construction then sum(...) else ? I would like to have some examples. .. as I tries different formulas and it seems it's not working
PL Dashboard - Calculations in both Rows and Columns
Hi, I need to create a PL report/dash board where there are calculations in both rows and columns as in the attached screen. How can I achieve this. I have selections for Period, Year, Products and Region. Based on the period and Year selected, the data should show current YTD, prior YTD and % Change. These are part of…
How to get all periods totals with tiem dimenson in to a target module without time dimeson.
Hi All, I have asituation where I need to pul previous 4 years totals into another module which do not have time as dimenson. How can I achive this. My module screen shots are as below. Blueprint view of same The data needs to be pulled into blueprint view of same is Thanks for your help. Balrama Krishna
2.3.10 Create DEM03 Demand Forecast Module
I think I have successfully completed the section but I feel like there is something missing. Other than the Growth Rate %, I have no other values in the other line items. Am I missing something or are all other line itms intentionally blank/zeros? AM I missing the formulas?
formula
How to get average prices from monthly data into Non months.
Dependent Dropdown by using filter
Hi, I want to use Dependent Dropdown list. I want to use Boolean Lineitem as "Filter Filter_Product based on data in " setting. Now I can filter by only 1 item. If we can this system, I can filter by 2 or more than items. In Anaplan, Can we achieve this?
Need Averages of months of prior years
Hi All, I have a situation where I need to get Average value of total sales in Jan17, Jan18, Jan19, Jan20 and Jan21 to be projected into Jan22 in a module. Please can anyone suggest how can I achive this. Thanks, Balarama Krishna

Calculation Functions

Discussion List