
Calculation Functions
Calculation Functions
Discussion List
- Hi , I have a text formatted line item which is a date .I want to convert it to Date format . I tried to break it into three Year ,Month and day using Value(RIGHT(Line item,4)) Value(Mid(Line item,4,2…
- Hello, my model has a list hierarchy of "FND01 Fund" and "FND02 Series". FND01 has a top level of "All Investments." The model also contains three modules with data values at each level of the hierarc…
- Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
- Hi, I have a date formatted line item (example: 4/1/2020) - this is in mm/dd/yyyy format However, i want to show as 1 April 2020 or 1 Apr 2020. How do I do that?
- I want to fix the length by appending zeroes :- Consider below example where i am having 3 Prod ID :- 1234 1234567 123 Below is the result i am expecting:- 0000001234 0001234567 0000000123 Generally w…
- Hello, we are using the spread function for bookings to revenue conversion. We would like to be able to spread by a non-whole number of periods, i.e. 51.6. Currently this is a constraint on this funct…
- Do you have any ideas to calculate this; what I need? If I make a line item called "for lookup" and use LOOKUP formula, I can do this. However I need to fill in "for lookup" manually. I simplify the c…
- I tried to create a simple SUM function. In a video it explains transaction as Line Item whereas I failed it as Line Item. So I tried using Transaction as a List. It worked out. Can you please let me …
- Line item subsets are one of the most powerful and efficient features in Anaplan, yet one of the least understood. The COLLECT() function is probably the only “black box” function within Anaplan as is…
- Hi Team, I needed small help to optimize the formula from Half-Year to Full-year. Current working System: If Jan 2021 (Budget) H1 Opening HC we were referring to Closing HC of Dec 2020(Actual) and IF …
- I have a hierarchy consisting three levels (product/product family/total products. Similar to the one in the trainings) and I tried to do some conditional formatting on it (need to use it as other tab…
- Hi! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and gu…
- The formula for Line item Revenue and Cost of Sales line items is not working and giving an error as below. This is from LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculati…
- I am building an output module to show some statistics around account pipeline by industry. I want to be able to show the smallest pipeline. Since some accounts have zero pipeline, the standard MIN fu…
- Hi, The question is about the following situation: A user makes a change to the grid and I want to perform calculations for another line item. I have the calculation formula written in a Python script…
- Hello, Is there a possibility to run external scripts from Anaplan UX Pages? I'd like to run my Python Scripts with calculation formula from UX page using for example Button is it possible?
- For this line item, it is needed to align the dimensionality of the Source Module to Target Module, so that the Target Module can reference the Growth Rate % of the Source Module. See below for mappi…
- It would be great to have a function to get current date and time. Timezone settings could be common for all users and maintained in the settings section
- Hi All, I've one use case where I've create list which includes YTD & YTG as list item. Then I've create a mapping module between Time & YTD & YTG list item as shown in below screenshot. But when I am…
- Description of the enhancement required: Allow the same action to run multiple times within a single process How would it help your business process: There are many situations in which this would be h…
- Author: Noah Jackson is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Anaplan does not have a RANDOM formula or function, but random numbers can be useful — I was…
- When creating a model using versions, one of the first questions is, “Should I use Native Versions, or should I create a Custom Versions list?” Will I need to do version comparisons; do the comparison…
- I am currently working on the Conclusion for Level 2. When preparing the export saved view for INV01 Beginning Inventory, I noticed I have significantly different numbers in my module as compared to t…
- Hi! I would like to use the Trim function to obtain up to 60 characters from the beginning. However, if the 60th character is a one-byte space (C2A0) in UTF-8, it is not recognized by the Trim functio…
- Description: To have an NPV formula function that calculates NPV exactly as Excel's period-based NPV formula does. Benefit/impact: Current NPV formula returns results as Excel's XNPV formula does (usi…
- Hi, I was wondering if there is anyway to have random number generator? Thanks
- Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y )…
- Author: Anya Skvortsova is a Certified Master Anaplanner and CoE Lead at Asana. Purpose FP&A is often asked to calculate the impact of variables on the total variance. There is more than one way to go…
- Does anyone know how to do a calculation in a ragged hierarchy which returns to the level of the hierarchy?
- Hey Everyone, I'm trying to find a solution in an excel sheet that utilizes an iteration function that I need to replicate in Anaplan. Basically, we take the previous number multiply it by 90%, then t…