
Calculation Functions
Calculation Functions
Discussion List
- this is the formula IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role,LOOKUP: 'SYS08 Employee Details'.Department] ELSE 0
- this is actual which should have 0 as given
- Context * My Destination module has the following dimensions: (1) Employee ID (2) Line Items (3) Time * My Source module has the following dimensions: (1) Movement Code (2) Line Items* Employee ID is …
- my resultthe lesson result
- Hello, What's the formula for looking up only future periods? In our module Professional Services Forecasting, I have actuals up to and including current period and blue inputs for forecast / future p…
- the result displays the actual version whereas it should show only the budget and forecast version the lesson reslutmy result
- Hi, How can i get back the data from Line item subset back to the original line item? I used the LIS as my dropdown to another module and i want to consolidate back the data from the dropdown to my ma…
- Hi, Can anyone please clarify whether spaces and newlines are counted as a character in the 80000 character limit in browser? Thanks and regards, Aakash Sachdeva
- I have module D03 that shows how many slots each product family uses. D03 is dimensioned by Time on rows, and PR2 Product Family list and 1 line item 'Slots' on columns. I am trying to write a formula…
- I have created Line Item subsets and certain modules for filters for other modules. My ultimate goal is to assign different line items to different list items (across the hierarchy as well). I have P1…
- Hi, I'm trying to be able to look up a total for all the individual days of the week from my historical data. i.e, I would need to look up all the Mondays in the Month of July and sum them together. I…
- Hello, I am trying to build out a very specific UX dashboard. I am trying to create a chart that displays all the data from a single list AND also add one additional data row that is from another modu…
- There should be a haschildren() function that takes in a list that a module is dimensioned by and returns a boolean, indicating whether or not the list member has a child. This would be especially use…
- Hello, Anyone Can help me to figure out the error in Bonus, not sure where I am mistaking it. I tried both way Copy and Paste the formula also written it. However, still have having same issue. Please…
- I use the same formula to calculate a value in a line item, it works in one module (Sales Qty - Motor) but it doesn't work in other modules (Sales Qty - Mobil and Sales Qty - Truck). I use different s…
- Hello, I am trying to build a UX dashboard that displays data from two different modules. In D01 Slots (PAGES: Version, Locations, Resource Groups, and Teams. COLUMNS: Time. ROWS: Product Names and on…
- I am writing calculation formula which I am struggle a little, hoping anyone can help me out. When writing calculation formula in Excel, we can use ( ) to group the calculation together, but Anaplan d…
- Hello Community, I have one module with version as dimension. In resultant module no version dimension is used How it is possible to flow value to resultant module..... Thankyou In advance Regards, JE…
- Hi, I'm trying to look up a LI for the previous 6 months average using a TIMESUM. The formula is working but no numbers are appearing. Not sure why the numbers are not appearing. The formula is below.…
- Hi, Generally it is suggested to use the TimeSum function if my target is not dimensioned by time. If my target is dimensioned by time, it is better to use MovingSum. But MovingSum doesn't allow start…
- Hello, I have a csv import that is not dimensioned by time and date in the same cell. It can not be changed for a monthly process import. I am 90% of the way there. I created an import module (not dim…
- I have a group of calculated line items that I want to remove the 'Use Switchover' functionality from so they don't pull in Actuals data. However, when I try to untick the box in blueprint mode, I get…
- Hi, I have explained everything in the below screenprint. Please share your views on how to handle this case.. Note: The module is data module where all the data is imported through csv file.
- Hi everybody! Need help to do the calcution within the list. Here is a list with items(#1,#2,#3,...), and properties of Input and Output. The Output is supposed to be the maximun value of the input fr…
- I'm running into a curious situation where I'm trying to use the Summary of a module that includes a Line Item Subset downstream in another module. I'll walk through the situation below. I built a sin…
- Hi experts I have use a list for time dim. and i considered four week in every month . i just want that in first 3 week there is the 7 days in the week and in 4th week there should be rest of day in t…
- Looking for help and advice on how to build out a discount function in our model. My company manufactures products and sells them to stores, for this example let's say our customers are Target and Wal…
- Most of the modelers know what is wrong with their formula, the moment they press enter and it starts toating system. There should be an option to **** the error processing in case of formula errors.
- Hi Anaplanners Has anyone built an Excel Search function equivalent in Anaplan? What I would like to replicate is: 1. Client has a text mapping table (screenshot 1) which maps Strings in Column B to t…
- Hi All, I would like to take a count of the users using the list Users for every month. I have a module with: Row: Users List Column: Time(Month) Line item : Number(whose formula is 1) I need to sum t…