
Calculation Functions
Calculation Functions
Discussion List
- As an Anaplan user tasked with helping your teams better understand their data through your Anaplan UX dashboards, we want to hear more about what your end users tell you. What kinds of visualizations…
- Title says it all, a XOR formula would be really helpful and reduce formula length when trying to test an exclusive or. For those unfamiliar, here is the logic table for XOR. It acts as an OR however …
- A detailed description of the enhancement that is being requested. We would like to request an enhancement that would allow to use LOOKUP and SUM with Formula summary method. Currently Anaplan doesn’t…
- There is no simple way to calculate contributions all children levels to the highest parent level - for product levels, time levels and location levels. The lowest level should be considered the value…
- Hello guys, I've noticed that my Boolean line items have stopped functioning somehow. It was okay when I first created them and stopped working when I added DCA. I checked the formulas and write acces…
- We want to get the End date but it should only fall on the weekday, we have tried other workarounds but it didn't work as intended. See screenshots fyr. END DATE (working days only) = START DATE + Dur…
- I have two columns, Column A and Column B. Column A is a manual input and column B is populated by an import action of the data of Column A. I have created a sperate module with Boolean checks to make…
- Hello, I would like to edit what is returned in the columns above a gantt chart. Screenshot below is what I currently see. I would like to remove/hide the year 2022 all together, and instead of showin…
- Hi Anaplan, I was searching for the use of the PREVIOUS function but on a list item but it is not currently possible. @peter_mcanena has suggested this but only in a discussion thread. So as his idea …
- Since Supply chain use cases are picking up, do you feel it will be good to have supply chain specific functions in Anaplan. If yes, then kindly promote the new idea I posted.
- I am trying to build a model that looks like the above screen shot. Tier 1 - Tier 5 are list items and everything in the top row are list items. I am having trouble getting any ending balance to work …
- Hi experts, How to write "concatenate formula" in anaplan. We have 3 proprties in Customer list. I want to concatenate first and second properties into 3rd property. The format of the properties is "T…
- Hi All, Need some quick help I want to import a date from 1 module to another module using Import action, however I'm error as "Invalid date" Module 1 - 1 line item (date1) | date format> currentperio…
- Hi all, Was looking to get some input on a calculation scenario as community pages were a bit vague (or I'm using the wrong keywords). Now, I'm sure most of us understand how Anaplan thrives on being …
- I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use t…
- When the user select Two Boolean Check the range is defined so I want to get the range of values respective months.
- Even though the Users list does not have a top member assigned to it, with the release on April 24, 2021, model builders will be able to use the following summary functions with the Users List: SUM, L…
- Brief description of the idea Remove 10 million item limit from the ISFIRSTOCCURRENCE function Expected benefit/impact Removing this limit would allow imports to be ran into large hierarchies that are…
- I want the user to select only one boolean line item at a time. When the user selects one boolean, other booleans should not be selected, and once the user unchecks the selected boolean, all booleans …
- Summary: Sparse cells within an Anaplan model are cells that do not contain and are not expected to contain data. The platform still needs to allocate memory space to these cells even though they are …
- I have two modules A & B where I want to use values of one line item of module A to be a part of a calculation in module B. Module A and B have no common dimensions in between them. Please help.
- Formula for Final exploration drilling (Dryhole) in excel is - Basically IF the first line items current year value is <>0 then then sum all the previous year and if the sum of all the previous year i…
- Hi Members, Can someone please guide me, how can I create an export action? As Export Action is not displaying.
- Just like we have functions for Financial (COUPDAYBS, COUPDAYSNC, etc) and Call Center Planning (AGENTS,ANSWERTIME, ARRIVALRATE) can we have something similar to support Supply Chain Planning? Like En…
- Hi, What is the best workaround when using the Lookup Function and you need a Formula Summary Method? Currently, Anaplan does not allow this and for some cases, especially using % accounts, it is best…
- Hi, We have a large reporting requirement for reporting versus prior year for reporting month and Year to date. The month is easily achievable but if we want to create views that compare Prior year to…
- Source Module has Year, Target module has Months. Source - Time dimension (YEAR), Cost center dimension, Line Item Target - Time dimension (Months), Cost Center dimension, Line item Source has rate by…
- Hi I have below module that is update every few days UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan two records were updated when the next time(eff from) the job runs like …
- Author: Iain Briggs is a Certified Master Anaplanner and Associate Director at Lionpoint Group. One known limitation of Anaplan’s NPV function is that it calculates across the full timescale. However,…
- May I know if I have this correct: Line Item Planning Period Filter: the formula is 'Sys00 Time settings by month'.planning period filter Line Item Planning period Filter weeks only: monthvalue('Sys00…