
Calculation Functions
Calculation Functions
Discussion List
- Hi all, I'm trying to find a way to return the value of one line item in a list, using two other line items. Background: I have one large module built off sequence numbers as the rows, and line items …
- Hi all, I am trying to create a "% growth" line item, where this line should be able to represent MoM, QoQ, and YoY on the same line (with or without the use of working line items) As time summary doe…
- Colour code the formula or function part of each component, so that we can see where the components are. All formulas and functions are blue and rest of text black.
- Hi, I am trying to figure out why my mothly cost will not populate based on the formula I provided. The goal is to show the monthly cost for only a certain time range and for the cost to not populate …
- Have the TEXT function convert the results of the ROUND function identically.
- Annoyance: URL link provided for specific model > user clicks it > user not signed in to Anaplan so taken to log-in screen > after logging-in, user is taken to models dashboard, *does not* continue on…
- Hi, everyone, I have an requirement from client that users select a standard/method (may be list types) from a drop-down in a lineitem (list formatted), and the graph/charts will automatically change …
- I have the following nested if, for the highlighted line item (see picture): IF NOT 'exclude' AND 'Sum fill rate gallons actuals' > 0 THEN 'Sum fill rate gallons actuals' ELSE IF 'Sum fill rate gallon…
- Sorry for the wall of text, I am attempting to articulate fully what my inquiry is, and due to information privacy, I am using sudo names as place holders. I am attempting to generate a summary module…
- Lets say I have a list to map any day in the year to an accounting month, because our accounting months don't always begin or end on calendar month boundaries. Accounting Period Date List (sample) Par…
- Summary: Unnecessary model size has a large impact on your Anaplan environment from using valuable space to slowing down key processes. Sparsity is one of the biggest causes of inflated models. Unders…
- Normally when writing code I can troubleshoot my code by stepping through it piece by piece to see where things fall apart. In order to accomplish this in Anaplan i tend to have to create separate lin…
- I have got two number line items as shown below. LineItem1 , LineItem2 , Result 1 2 1(2) 3 4 3(4) 7 10 7(10) I want to get the result as shown above for the two line items. Ideally i need a concatinat…
- Hi, I have a module with 3 or more lists, and Value and Rank line item. I want to rank Value for each combination of items in those 3 lists. However, I find that RANK function can only accommodate 1 l…
- Hi everyone, A question about how SSO works with new workflow method - since the new workflow method will enable an automatic notification email which contains the URL linking to the dashboards that t…
- Hi Team, I am trying to do the currency conversion where countries will be reported in 3 currencies USD,Euro,LC Now if the country is suppose France then only Euro and USD should appear in the drop do…
- Hi all, Perhaps a straightforward question, however I cannot find a direct answer. I would like to have a BLANK formula for numbers, so IF ... THEN BLANK. Currently I have IF ... THEN 0 ELSE ... , how…
- I am writing an IF Function (IF START()>CURRENTPERIOD() THEN TRUE ELSE FALSE) the result will be a Boolean. How do I make it apply to the next 6 Months or PERIODS? Thank you
- I am working on a module in which have two related line items (L1 & L2)& a dimension "Period." For Period A is L2=0, Period B L2 = Period A L1 and so on. I am trying to figure out a calculation for th…
- When I drill down into a calculated numeric value, I want to see the full numeric value of the source cells that play into the calculation. Right now, I only see the rounded value based on the Number …
- Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my c…
- I'm trying to build a module that displays only the top ten cost centers based on a variance line item that I've got calculating. I'd gotten it to work with a RANK formula and then a boolean line item…
- Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my c…
- Hi I have a requitmemtn where the data is maintained in a List and when the user updates the data (edit/create),then we should capture the system date in a column in the list. This is to know when the…
- Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my c…
- Description of the enhancement: Currently using the TEXT function it will convert the underlying number. For example, if you have: Line Item 1: Number format, set it to 5 decimals - value: 0.0000005 L…
- Could not manage to “paste link” the TO PAY (SAR) column (manually inserted in module X) from X module to Y module. The look up unique identification is the Transaction No. OR Document Number. Can you…
- Hi , I want to use a combinaision of line items in a module I published as a Dashboard as filters for that Dashboard. This without creating a Button for refreshing the result in the dashboard but to h…
- Hi all, I've got a line item where I import date from AWS everyday. I also have a list called Split Week where I have two 'Date' formatted properties called Start of Week and End of week. Is there any…
- Hello, One of my client is operating some models which drives a connect Supply Chain Network, and they need a stepwise debug execution so as to see what's happening exactly in the formulas. Due to the…