
Calculation Functions
Calculation Functions
Discussion List
- 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 Ro…
- 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 " …
- 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?
- 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 re…
- 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 Metr…
- 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 pe…
- 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 shoul…
- 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 fo…
- 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 an…
- 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…
- 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 co…
- Hi - P2 Product list has parent. Why formula is not pulling product family here?
- 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
- 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 Re…
- 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…
- 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 ar…
- How to get average prices from monthly data into Non months.
- 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 …
- 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 t…
- Hi, I want to use Workday function in Anaplan. It is used in Excel. In this page, we can built using a calculation. But I can not imagine how calculate it. https://help.anaplan.com/d61d7264-24d0-4357-…
- Could someone please tell me what I am doing wrong with these formulas. @Misbah 1. Beginning Inventory = IF 'SYS01 Time Settings By Week'.'1st Week of Timescale?' THEN 'DAT01 Beginning Inventory'.Begi…
- I want to use movingsum function. But I have a restrict of calender. 1月3日1月4日1月5日1月6日1月7日1月8日1月9日 value300400007000900 Workday☑☑ ☑ ☑ movingsum value2222222 Value(movingsum)14002000 ※Value(movingsum) =…
- Hi, This thing is driving me nuts. My formula for "Confirmed PO Delivery" works when referring to the Shipping Time Weeks but won't work when referring to the Final Shipping Time Weeks. Both line item…
- Hi, I am in need of a solution to this dilemma and being new to Anaplan I can't think of way to write the formulas. The goal is to be able to pro-rate actual days work from days on leave. The PRO rate…
- Hello Community! Is there a way to calculate the number of complete months between two dates in Anaplan? E.g. Start Date (MM/DD/YYYY)End Date (MM/DD/YYYY)Number of Complete Months07/17/202007/16/2021…
- I want to create the average of every month of a LI that displays Daily totals. One of the LI's will be my total account balances on a daily bases, and then I would want to create another LI that woul…
- Hello all, I am facing a situation that seems weird to me. In a module, I want to repatriate the value of a forecast made last month. So I create a line item that uses the LOOKUP function : previous F…
- Hi Community, I am trying to rank based on concatenation of two dimensions and rank doesn't seem to be working. However, when I remove "group by" condition from rank formula, it ranks. Why is it so? C…
- When I apply the Start function below against a Month period it returns the week period start instead of the start of the month for the month period. The calendar setting has calendar type set as week…
- Hi Everyone, Please consider following example, NameTypeAZPBRBZRBRCZRCLDZWIR I have a module A with 'Name" as list and a line item named type as shown above, now below I have a second module B with a …