Calculation Functions

Filter
How to apply filter on line items? There are 4 line items Baseline Forecast,Growth Rate %,Default Forecast,Initial Demand Forecast. I want just 2 line items Baseline Forecast, initial demand forecast. The chart should show the monthly Baseline Forecast and Initial Demand Forecast for two years. so I want to filter time on…
how to write if column (a list) contains x then 1 else 0
Hi there - am new to anaplan have only used excel extensively. I need to add a conditional colum (col 2)n based on another column (col1) which is a list type. That is if col1 contains "x1" or "x2" then 1 else 0. Thank you
Interesting Build request: other methods?
I had a scenario posed to me and took a stab at building it. I would love to get any feedback or alternate methods of tackling this. Scenario: * Your user will be entering two number inputs * These inputs will be in a module that has Months * The user wants to see the numbers that they would need, month by month, to move…
Run-off activities and innovation
Hi! I'm currently working on a KTLO project within Anaplan and we are looking for new ways to drive more impact to our client and innovate in our run-off activities. For example, we have come up with a model size tracking dashboard in order to do quality checks on how data gets uploaded every day. If we detect a huge…
immport error
Import ErrorI will get the below error 9.1 Import Historic VolumesModel object "'DAT03 Historic Volumes'.Export" could not be located* 9.2 Import Opening Stock * 9.3 Import Shipping Metrics
Formula
Add a formula to the Growth % line item to convert the DEM01 Volume Growth Rates.Growth % (monthly) value to weeks. WEEKVALUE() is used, but didn't understood.
Model Versions Lookup
Hi, I have a source model in which the model versions(default versions) product list and time as a dimensions. There is an version selection module where the user can select the base and target version for dynamic variance calculation. The target module has Product and time dimension. I need the value of the External Base…
Mapping
I am facing problem with mapping. In sheet 20 jan month name, in grid view jan 20, so facing problem with time mappaing.
Finditem Fails to Detect Valid List Member
Hi Anaplan, I've come across something strange and wanted to ask if anyone has any ideas what is going on or if this is a bug. I am creating a List using a Saved View that contains a list of codes (text) to be added to a list. The import action is set to use code only, and the source codes are imported into both Name and…
Formula for a Module
Hello everyone! I'm having a problem, I need to populate this Boolean line item (circled with green) on this module with the data on the list subset. But I can't select the list subset in the formula bar. Thank you!
How to do month to date(MTD) calculation in a module
How to do month to date(MTD) calculation in a module
Conditional Formatting issue
Hi, Can I ask for help on the conditional formatting part. I have an input template where once the user inputted more than a hundred percent the cells should turn red stating that this is the maximum percentage they can enter. I created a rule (see below) but it seems to be not working.See below Both row and column are…
Limitation on Input Values
Hi, I have a question which might be fairly simple to some of you. So I have this Input template where Users need to input values in terms of percentage. But the Users preferred to limit the amount to only 100%. See below so as you can see on the screen shot provided. under the column Percentage % I was able to input both…
Logic to Solve different companies mapping to SKU as input
Hello All, I'm trying to solve the below logic but unable to; need your help on the same; The below module applies to the list SKU. and maps to the company which is applicable based on the boolean. I have input data sales price by SKU and by month and by all the company Now, I would like to get the sales price by SKU by…
NPV and Amortisation
Hi Guys I am running into a problem using the NPV calculation and a subsequent amortization calculation. Please see attached: I used the NPV formula to calculate the NPV of a 12 month variable cash flows. This is equal to the opening balance of a liability. 213,473) When i develop an amortization schedule including…
Percent Growth Formula Logic
Hello, everyone, I'm trying to put together the formula to display the appropriate Unit Increase by & Total Unit Value outputs in the table above. The logic should go thus: The 2% growth for FY23 should use the 100 unit value from FY22 as its base. The formula would go thus: (2% of 100) The 5% growth for FY24 should use…
Daisy Chaining versus Avoiding Duplicate Formulas?
Hi All, I have a question about daisy chaining versus not repeating a formula. From what I understand, the engine will calculate the below module faster if I didn't reference Division and Deal Size in the Selected line item. Line itemSelectedDivisionDeal SizeFormula(ISBLANK(Division) OR FilterSelections.Division =…
How to convert flat data into monthly - GL example
Confused on how to work with this flat data and derive monthly values from it. Appreciate the help! Each row is a unique combo of Account (GBAID), Ledger Type (GBLT) and Year (GBFY). The snippet attached is 4 entries for the same account and ledger type for 4 different years. GBAN01-12 are entries by month. For example,…
Calculated Codes using Attributes - Best Practices
We are working on a project to migrate from an Employee Hierarchy to a Position Hierarchy in Anaplan and are looking from some input from the community on Code Creation best practices. Since we do not have a good external source of data for position code, we've decided to create our own Position code within Anaplan. At…
3.3.7 Activity: Add DCA to Inventory Ordering
Hi Anaplan Moderators, Can someone help me out! to check if my formula and the results is right or wrong. Thank you The pics below is the results and the formula:
Add formula to a Has Data? Line item
Hello, I am new to Anaplan platform. Now I am working on Level 2 model building training. Here I have an issue to write a formula to line item. I don't have any kind of data in SYS13 Account Filter Module. I have data in DAT03 Historic Volumes Module. In DAT03 Module I have only one line item Volumes and I don't have any…
Drill Down
Hi, I have a formula applied to a line item which is not giving out the correct result, and if I drill down the formula, the pop-up screen is not considering he other modules for calculation which are there in the formula. Can you help where is the lag in the formula. Have attached a screenshot for reference. Thanks.
Level 1
Hi I'm on question 6 of Level 1 and I keep getting this error. I've double checked my format and names and think they are right so I don't know why i keep getting this error Medical Costs = EMP02 Employee Expenses.Medical Costs[SUM: SYS08 Employee Details.Region2, SUM: SYS08 Employee Details.Role2]
NPV without an outflow
Good morning I am building a model consisting of future variable monthly cash outflows without any cash inflows. I need to calculate the NPV of that in order to convert that into a liability using the variable cash outflows as down payments.. The NPV formula require cash in and cash out. What are your suggestions?
Implement Slow Changing Dimensions in Anaplan
Hello I am facing a scenario where I need to implement Slow Changing Dimension ( Time Validity using Start Data and End Date ) for product & customer combination. A product can be sold to more than one customer. And the price varies over time for each of these product customer combination. I need a module to track the…
Linking Line item to List
Hello folks, I am new to anaplan and stucked at one small requirement. We are having two modules i.e. Module 1 - Product segment (Defined in List for different products) with transportation cost line item and Module 2 - Transportation cost for Each segment in line items (input). Need to know how can i link the…
Level 2 Sprint 2 DEM03 and DAT03
Hi Team, When reviewing my latest workings and forecast per DEM03 and referencing this against the example for the baseline forecast DEM03 in sprint 2, I couldn't help but notice that my figures are different for the future periods commencing in Week 1 FY21. I'm not sure whether this is related to an error in DAT03. Please…
Creating a new model - issue
I got stuck at one point in building a new module and I thought maybe someone could give me some advice. 1. I built an INPUT MODULE that has a lot of line items (about 30) - some of them are filled uploaded file and some are calculated based on other line items. For this INPUT MODULE data is loaded for two version…
User Dimension-User Filter
Hey, I have been stuck on a particular issue. I have a module dimensioned by list A. One of the line items is called "Approver", list formatted to a fake user list-subset. So every list item of List A has one approver of its own. In my second module which is also dimensioned by list A, I want to ONLY show the list items to…
9.2.5 Activity Error
Hi I am not able to edit 0 to 5% in unit cost %. Please guide what could be wrong here. Screen shot attached. Thanks -Pooja

Calculation Functions

Discussion List