
Calculation Functions
Calculation Functions
Discussion List
- Hello, Requirement :- The parent should have the average color of its children. I have an Indicator(Red , Yellow, Green) coming as a Text input from the Source. The requirement is to roll up to its im…
- I keep getting this same error message every time I enter a formula. I'm not sure if I'm entering the formula wrong, but can someone help me?
- Hi Team, Assuming the Model's requirement is a monthly time dimension. However, the Cashflow Forecast requires input for every 7 days, or weekly set up. Is there a way for the previous date ending cas…
- I've followed the instructions as stated in the lesson and this is my result. How do I allow the forecast to show the different products? Anyone who can help would be greatly appreciated. My model is …
- For 2.3.9.1 nothing is populating whenever I run Process 9 Import Data from the Hub. I didn't even get an error as most did, it's just zeros. My data hub numbers are there but nothing happens.
- Hello We have multiple versions in our model (ie Global 1, Global 2 etc). We created the module where user can pick the versions from the list that was created (please see the image below) and the lis…
- Hi, Need help for 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module It was said to enter 5.00% for the FY19 Unit Cost % in REV04 Price Growth Rates module, but it hasn't carried forwar…
- Good day, Currently I work on a sprint 3 and stuck for a long while on a Shipping Method formula. I went to Anaplan Community and found out that somehow I skipping the line item "Supplied by" in a mod…
- Hello. I noticed my shared cost values are higher than the model example, but the other values are the same. Any ideas why?
- Hi, I do not know why my G2 Country will not display the Country names in my G2 List. Please advise I have trouble shooting by adding a properties to help display the names and then calling upon that …
- Task: Calculate the total monthly working hours for FTE's; new employees should be prorated based on their start date, employees that are leaving should be prorated based on their exit date. All absen…
- Hi, I have been trying to trouble shoot populating my P2 Product LI in the SYS03 Account>Product Details Module. I have the LI formatted as a List for the P2 Product List and using the formula FINDITE…
- Hi. I'm on 9.2.5 and my number isn't formatted correctly even though I'm using the parameters from the lesson. Any suggestions
- I've been having trouble understanding the concept of mapping and how certain values are supposed to be categorized together. If anyone can help me get beyond this error message that would be great. I…
- Hi, I have tried almost everything and have been stuck on this part of the model build or a day now. I have changed my dimensioned and tried to get them to match and still not working. I'm trying to p…
- Hi, Question please. What is the best practice if I need both the columns and rows as a line item because I need to calculate the variances and the difference to maintain the clients preference on the…
- The current drilldown functionality in the New UX is not compatible for complex formulas. It would be a great improvement if the formulas can be formatted (like in the classic) with bolded text for fu…
- Hi Community I have included the formula as requested into the formula line of Revenue however it's giving me the attached ERROR MESSAGE which I can't seem to rectify. Any assistance regarding this wo…
- It appears that there is no out-of-the-box function to sum all values up to the current period to return the 'inception to date' value. A new function could be very similar to MONTHTODATE and YEARTODA…
- Is there a way to use TIMESUM or MOVINGSUM to sum all values in a time series up to the current date? Essentially creating an 'inception to date' calculation. For example, if I have a monthly time ser…
- Could you please help how do I get to access the application hands on for practice and further to perform activities to answer the exam questions through my system LIVE. I'm a beginner trying to give …
- I have Order module(Region, Order) Order(1,2...) comes from each Region. Order has Item and Amount. I want to aggregate item-amount by dynamic Region like this table. If Users chose the Europe, Item-A…
- Hi guys, Got a question I need assistance with. I have a number of lists that follow a hierarchical list, account level 4, 3, 2 ,1. At level 4 each account also belongs to an accounting group (online,…
- Hi, We are trying to create a formula that will subtract the sum of all the List Items, (excluding List Item 'Other'), from the overall Total of all the List Item totals added together. We were thinki…
- Hello, I am attempting to calculate the % of a parent forecast each child makes up in a given time period. For example, a month has a 100 unit forecast in America. Texas makes up 60 units and Californ…
- With newest UX for modeling I found the missing opportunity to see the pretty syntax highlighting in models being in deployed mode. The double-chevron icon is unavailable during deployed mode so i can…
- Actually we have a module that includes a column with dates, and we want that Anaplan identifies if a date from the column has passed or not yet. For that we have created a line item, and we would lik…
- Hi, I need to calculate the three months average based on the historical sales data the year before. For ex: Jan 20 Feb 20 Mar 20 - Average values should go under Jan 21. 100,0,100 - 66.7 Jan 21 value…
- Hi, Need help on how to count the number of times a Text dimension LI shows up under a List LI. We have tried to use the SUM function as well as LOOKUP function, but they did not work. For Ex) We woul…