
Calculation Functions
Calculation Functions
Discussion List
- I searched for the posts regarding zeroes vs null values but don't think I found an answer to my question. So in module A, when people create projects they input values. These values are brought to mo…
- Is there a function to change a list value to a text? I want to use the & operator with list values, but it only accepts text. When I try just using the list-formatted line items, I get the error belo…
- Hello I need to solve a Supply Chain distribution planning problem through optimizer. I am solving for a small network of warehouses & depots, you can refer the same in the attachment provided. Follow…
- Hello, Is "zero padding" possible in formula of Anaplan? What I'd like to do is, for example, changing "123" to "00123" or "1234" to "01234" if a number has to be held as five digits. In other words, …
- Hi guys, could someone tell me how i can possibly do this in anaplan? i have a module dimensioned by a list, a list of compagnies(A,B,C). this module is published in the new ux as a worksheet and im u…
- I have an aggregates sales forecast module that only has time dimension. The sales line item in the aggregation module is doing a lookup at sales metrics module that has stores and scenarios as a dime…
- Hi Friends, is there any formula / straight way to know the month number of the Current Fiscal Year? e.g. if the CURRENT FISCAL YEAR in Time Setting is as below Then Apr'2021 is first month of FY22. H…
- Hello, I am wondering if there is functionality which would allow ranking based off of a specific starting value. For example, I have 'Reference Line Item' = 3 (number formatted). I then have my 'RANK…
- Hi All, I am receiving a very unexpected error when trying to SUM Anaplan weeks into Anaplan Months. The reason we are doing this is because the clients has an unusual calendar that we are not able to…
- Is there an easier or faster way to copy data from FY21 Forecast version to FY22 plan version without copying it module by module? Also, I need to keep the current FY21 plan intact. so the result on p…
- Hello, May I get help with this part. I tried to add formulas to these line items but it does not work". There is an error each time. Unit Price Growth: IF 'SYS00 Time Settings'.Forecast Period? THEN …
- I have Line Item A, Line Item B, Line Item C, and Line Item D. How do I get the average of those line items? I know I could add them and divide 4 but I was wondering if there was a formula? I tried th…
- Hello guys, could some kind soul help me with this ? i have two modules: - module 1 : line item "account" list formated, list name is "group account" , line item "partner" list formated and list name …
- Hello all, I am having a problem with Inventory Ordering Module. I thought I did everything correctly but my module's suggested order amount doesn't match with the given screenshot. Here is my module …
- I have a time SYS module that has the last month of the next years forecast (12/1/2022). When I use the PERIOD() formula and reference this line item it returns nothing. The module where I am referenc…
- Is it possible to have period start/end selectors to pick the run rate period instead of a moving average? Each time we add actuals it changes all the forecasts making previous adjustments and overrid…
[BUG?] Summary Items showing non-zero values for Line Items with zero values after running Optimizer
Hey everyone, I am encountering what seems to be a bug with one of the modules I am working on, where the summaries of the line item seemingly do not update after a change in values. As you can see in…- There are times when a code needs to be generated in Anaplan and it would be really handy if we could use a simple hash function to do this (especially as Anaplan's code limit is 60 characters). The H…
- Hi, I am using a TIMESUM average and I'm wondering if there is a way to exclude zeros from the average. Formula: TIMESUM(Build Factor, TIME.'Q2 FY16', TIME.'Q4 FY19', AVERAGE) Pictures attached.
- Hello all, I need to calculate a sum of costs from P&L which are base for subsequent calculation of revenue (sum of costs * (1+margin%)). The tricky part is that we need dynamic setting for identifyin…
- Trying to pull the SUM of X list from a module but receiving the below error. Source module is having a list datatype line item i.e. COST CENTRE (though dimensioned with other list) and the target mod…
- Hi All, I am wrapping up the Level 2 training and am stuck on why my data for everything new york is not populating. My guess is that I do not have 'submit purchase order' as a formula and therefore t…
- According to this mini demo, time-functions are divided into two categories: non-time series functions and time series functions. Non-time series functions include: * ADDMONTHS, DATE, DAYS, END, INPER…
- I have inserted a formula successfully but i am not getting any values for other line items. Can anyone please help in this regard.
- Hi guys, im trying to do this lookup. I will start by stating the goal i want to achieve: i have 2 lists formated line items in module 1: Product and Partner. In module 2 i have one list formated line…
- I have two modules, the first includes versions as a dimension and the second doesn't. There are 4 versions, Actuals and 3 forecast versions, with one of the forecasts marked as current. If I create a…
- Hi All, I am trying to write formula for shipping time in weeks line item in INV01 I am referencing TRA01 shipping time(weeks) as source in my lookup and SYS08 code as Mapping. and I am seeing that TR…
- Hi, I have a P&L with 20 line items currently in a module. This has 2 other dimensions Entity & Division which are Lists. It has native versions as well and monthly time. I'm trying to create a new mo…
- Hello friends, need your help in nailing down the problem which i am unable to point. * Module test has 2 views..1a and 2b * Module has following dimensions i.e. Model TIME, 2 lists & 2 line items * W…
- I know I can't get answers, but I feel like everything should be correct in my formulas. However after I entered all of them, they just populated 0's. I've checked the source material it's pulling fro…