Calculation Functions

Hi It would be amazing if it was possible to format on a dashboard and then push the formatting back to the source module or saved view. Thanks, Usman

All right, I did the very easy Makelink modules and added it to a dashboard. What my "click here" button should do is direct users to a Sharepoint on our network where we made/created documentation related to our dashboards. If I make the URL www.google.com it works. If I put our HTTP://Company Sharepoint URL (example:…

Adaptive Insights has this feature where an end user can "split" the value of a an input cell into several values to have that amount roll up and be displayed as a line item. Customers of Adaptive really like this feature and in competes with Adaptive, we get asked for a similar function. 

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 as the columns (no page dimensions). Each row is a seperate transaction (either a product being added or a product being…

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 does not allow us to use OFFSET or PREVIOUS, what should be the best workaround for this? (Note: with the creation of new…

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 in the months it doesn't apply to. My issue is the cost will not populate at all. Attached are screenshots of my formula and…

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 to model at original link. All other tools used by me at Anaplan (with the frustrating exception of SFDC) would drop you…

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 the data items accordingly. Let me put it in more details with some examples. Driver (parameters) Image:…

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 gallons PY' > 0 THEN 'Sum fill rate gallons PY' ELSE IF 'fill rate gallons FOR movement avg' > 0 THEN 'fill rate gallons FOR…

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. I am using 2 independant heirchies, with one of the line items/fields in the first heirarchy matches a value in the second…

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) Parent Code Accounting Month ... ... ... ... 5/24/2018 May 18 5/25/2018 May 18 5/26/2018 Jun 18 5/27/2018 Jun 18 ... ... ...…

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. Understanding what sparsity is and how it impacts a model is the first step in knowing how to reduce it. Course Objectives: By the…

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 line items with pieces of my formula to see how they compute. To help a modelbuilder better troubleshoot formulas without…

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 concatinated value. Could you please assist me in achieving the same in Anaplan.

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 list in the Group option. How can this be done? Regards, Andre

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 the users need to update, how does it work with SSO? For instance, if an user doesn't have Anaplan logged in at the moment,…

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 down list as Euro is the LC i.e. LC in the above list should dis appear. e.g. For France Only Euro and USD should appear…

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 ... , however it has to be blank instead of zero. Is there a certain formula that works for numbers? Kind regards, Mickel

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 the Non-time series module. Example of module given below: Period A/Period B/Period C/Period D/Period E L1 13/15/16/18/19 L2…

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 format that I have set for the cell. It would also be helpful to, as a user in a dashboard, hover over a value that has been…

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 current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…

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, but then when I started trying it with selective access set up on the cost center, it broke and I only see a few of what…

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 current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…

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 data was last updated. Appreciate any pointer on how this can be acheived . Thanks Regards rabakaran

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 current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…

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 help? Module X PAGE: Bank Element List Vendor NameVendor CodeVendor CategoryDocument NumberAmountTO PAY (SAR)OUTSTANDING…

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 have it updated automatically according to the selection of those 2 lines Items. Is this possible and how ? Thank you in…