Calculation Functions

Error message: Cannot breakback
Hi all, I have a dashboard for forecasting and I want to allow users to copy from one quarter to another quarter, using breakback (at a quarter level instead of monthly level). For some reason, whenever I try to copy values from one quarter and try to paste them into another quarter, I am getting this message: Cannot…
Pouplating year value without Time dimension
Hi All, Can you please help me in populating the attached years by formula , where I am not using Timescale in the module and my Mapping Year (line item) format is Year. CHRT** and YR** are my two dimensions used here.
Improve FINDITEM() when used with Time
Similar to improving imports with time periods (Idea Link), it would be great if the FINDITEM() formula was tweaked when working with Time, to make the formula return time periods for strings like Jan-20. Reason for asking (lifted from my previous post in the Idea Link): The standard excel format for Month-Year is MMM-YY.…
How to Lookup in different dimensions
Hi everyone, I have two module. I want to post values from a module that does not have a date dimension to a module that has a date dimension. Also, there are two target Line Items. The mounting image is as follows. I would appreciate your advice. Best regards.
Simple seasonalization question
I am having trouble interpreting Anapedia's Time Aggregation functionality which states that: X = YEARVALUE(Y) * Seasonality% Will allocate Y according to a seasonality percentage (not shown). I have the following simple example with three modules: Annual sales by product group and employee Seasonal percentages by product…
Excel '^' Operator in anaplan
Hi Team, I need an help in using '^' operator(in excel) into anaplan, while looking through all available operators and constants I could not find this operator. Is there any alternate function for this? Thanks & Regards Madhu
Numbered list import error
Hello Friends, I was trying to import values into numbered list, I was thrown with this error. Please let me know, where I was wrong. Regards, Sravan.
Need assistance in Formula
Dear Friends, I have some products and each territory allocation. I want my final module to look like M-1 I have attached .csv file (P1) for reference Regards, S K
Formula Summary type on LOOKUP or OFFSET
Hi, We are a NZ Telecommunications company. We have the need to report metrics such as ARPU $ (avg revenue per user) and Avg cost per user across our segments. I can do this compared to our forecasts & budgets easily but if I try to do this for Prior Year or prior period data I am stuck for a solution. I cant use formula…
Level 1 Model Building not a recognized line item or list member
Hello, I am trying to add the below formula and I am getting this error.
SUM function based on User-specific filter
Ok, here's the situation: - I have a transaction module - The transactions are children of Cost Centers - The transactions feed into a reporting module using a SUM function - There are certain "special" cost centers that exist across different functions\parents in the Cost Center list - I need to be able to give the users…
YEARVALUE function
Syntax YEARVALUE(x) where: * x: Source line item or property to be summarized. Format Input Format Output Format x: Number Number As from above we can see input & output format should be number for YEARVALUE function. Can anybody explain how this function is working for boolean format (please find the attachment)
FIRSTNONBLANK FOR ALERT MONITORING
OK, I've already gotten one question answered around this. Just to recap, I'm creating an alert monitoring system that will flag when a stock goes low stock or out of stock. I have a BOOLEAN for when a stock goes below 1 week of inventory and another line item that displays that start date of that week should we go out of…
Logical Functions-IF ELSE statement - Trying to apply condition where line item text contains "DEC"
Hi there I wish to populate the line item "FY TEST" with the future financial year when any "Dec" month is selected in line item "End Period (Last Actual)" For example, return "FY20" in "FY TEST" when "Dec 19" is selected in "End Period (Last Actual)". The formula I have tried to write for line item "FY TEST" is below but…
Time range >= check
Hi, I have a module with time range(quarter) as dimension and also I have time range quarter as a List: I want to populate as true(boolean parameter) for all the fields i.e >= List time range as below: Thanks.. Q1FY19Q2FY19Q3FY19Q4FY19Q1FY19TRUETRUETRUETRUEQ2FY19 TRUETRUETRUEQ3FY19 TRUETRUEQ4FY19 TRUE
Alert Monitoring
Hello Everyone, I've setup a weekly scenario tool that shows your starting and ending weekly inventory with the line items being the key factors like Forecast, Sales Orders, Purchase Orders, Planned Orders, etc... I export this data from SAP. I'm basically trying to recreate the planning book because our company doesn't…
Reducing (or declining) balance depreciation
Hi We currently have an asset forecast module set up that calculates the NBV of assets over time which currently only uses straight line depreciation so it's reducing by the same value per month...simple. However we have just changed our depreciaition policy to use reducing/declining balance depreciation and I am not sure…
Cumulate Performance
Hi all, I would be really interested to hear your thoughts on the Cumulate function and how you have best utilised this without affecting performance? I understand on longer time ranges it is usually, but not always, beneficial to use Previous instead of Cumulate however would you also break the function out in several…
Nested IFs (early exits) vs. OR/AND?
I'm curious what others' thoughts are, or if there's been any testing done regarding the performance difference between nested IFs vs. OR/AND. I found a very old thread on this topic from 2014, but I expect the thinking & research has progressed a lot since then. Let's say I have multiple criteria I need to check in order…
Data break down based on hierarchy
Hi, I'm wondering if there's a way of breaking data down from a top-level? The data file that I get is an import that comes in at level 2 in my hierarchy. I need to then take this data and show it applying some rules in a module uses my lowest level of data (l4). Thank You Hina 🙂
Linking two modules with two different dimension
Hi All, I have an issue that I may need some help with. Below is the sample table: Gencon Module (Source) - GenCon List Inventory Module (Target) - Inventory List Gencon Module is the transactional data of the client. In the Gencon Module it is normal to see multiple transaction code with different Start Date, End date and…
Source and target line items have different formats and lists when trying to use lookup.
Hi, I am in need of some ideas, on how to solve a problem I am facing. I have these 3 modules (picture below). The module OC Expected Renewals contains numbers. OC Expected Renewals already pulls in data from from the module 4f ACV Calculation, but, now I also need it to pull in target values from 5f Official Customer ACV…
Tagging Duplicate Items
Hi All, I was hoping to get some with a problem that I'm trying to solve. I have a module with a line item that is list formatted. In this module, the 'applies to' is a list that has 7 values. The line item in the module has the following items shown for each of the 7 rows: item 1: Product A item 2: Product B item 3:…
Creating an As-Of Version
Hi, I was wondering if users can create an as-of version in Anaplan. Thanks in Advance, Daniel
How to model annual inflation in Anaplan?
Hi Anaplan Modeling Experts, I found it is not that straightforward to play with timeseries data in Anaplan, when the calculation logic for a specific item is referring to the values of itself from the previous period. In this example, I am trying to model the annual inflation rates. In Excel, it is quite easy, just type…
Option to pick a separator, when using TEXTLIST as "Result = Source[TEXTLIST: Mapping]"
Good to give user the ability to pick or type a separator instead of default comma, as there might be commas in the orginal text strings already.
Boolean Formula - Match line item with date to date on column i.e. item(time)
Hi, I am trying to write a boolean formula that will create the check mark where the formula finds a match between another line item containing a date and the calendar date on my columns, i.e. item(time). Attached are my current views and what I am trying to accomplish. Can someone please help me write this formula? I do…
Delta load for Numbered lists
How to implement Delta load for Numbered lists in Anaplan ?
Fake to Real Timescale
I am trying to map a fake time list (months) to the real months timescale so that I can create a time filter off of the real timescale for the fake timescale. What would be the best way to do that? The fake months list has the same format at the real one does (MMM YY).
How to flag a period using boolean?
I have 12 months worth of data, but only want to flag Aug-Dec. I can't do it by checking all the boxes as there are over the 10k limit, so I'm trying to develop a formula where it essentially says, if period > July, true else false... Any ideas on how to easily accomplish that?

Calculation Functions

Discussion List