Calculation Functions

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 way I can check if the Date of import lies within the 2 properties? Thanks in advance. Prateek

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 fact that most of formulas are bid over complicated, step by step debug execution would be nessary. Any ideas and comments…

Is it possible to use the IRR function to calculate only a subset of the cashflow? For example, in Jul 18 I'm looking to calculate the IRR of the cashflow from the beginning to Jul 18 and then on Aug 18 it will be from the beginning to Aug 18. In excel you can simply have the formula as IRR($H2:I2) and apply that across…

Hi, guys! I'm doing a logical formula in my module that says if a Unit (Line Item) is classified as Current (List: Sales Type) then it will perform a certain calculation otherwise if it is Non Current (List: Sales Type) then it will display zero. Can you please recommend me a formula for this? Note: I have uploaded the…

Hello, Is there a way to get the TEXTLIST function, when used in the aggregation format, to only display unique entries? I have the formula working in my model, but it is displaying every entry under the parent, rather than unique entries. I know that the normal TEXTLIST function has a "UNIQUE" option. Best, Matthew

Description: When selecting several cells in a module within a dashboard, we would like to see the summary (and perhaps average and count) of the selected cells displayed as well. This is similar to the customized status bar in Excel that shows the Average, Sum, and Count of selected cells.

in regard to the mailto anapedia, how to have the body of the email to have multiple lines? i.e. how to make %0D%0A work in to the mailto formula?

Hi Team, My model has 4 versions: Actual Version: Monthly Input Forecast Version: Once yearly Input Q2 forecast Adjustment: Q3 Forecast Adjustment: Let's suppose we have forecasted for whoel year and users are done with Actuals input of Jan,Feb,Mar,Now the Higher management wants to adjust there forecast for Q2 in which Q2…

Description of the enhancement required: Enabling slicer facility in Anaplan tool like the one in Excel https://support.office.com/en-gb/article/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d How would it help your business process: Customer would need this facility of Slicer enhancement due to multiple…

Description of the enhancement required: Include a way to format weekly dates by Start/date - end/date such as in excel. A story for why they want the enhancement: Currently we have a gantt chart view in Excel which shows run dates on the columns with the activity detail in the middle of the grid. It is easier for us…

Description of the enhancement required: Add new function AllPeriodsValue An example of the enhancement: The AllPeriodsValue function would work like YEARVALUE, but utilizing periods rather than year. It would have a parameter to choose whether a Brought Forward value should be included in the result. How would it help…

Description of the enhancement required: Blank dates should not be taken into account when a line item is date formatted and the summary method is set to "minimum". Anaplan should designate the lowest applicable date when this summary method is chosen An example of the enhancement: If there are three child nodes under a…

I want to be able to enter formulae in data entry cell, e.g. (100+30+40)% and pressing enter shows the result

Description of the enhancement required: More rounding options An example of the enhancement: ability to easily adjust summaries between whole dollars, thousands, millions.

I am looking for the best solution how calculate/distribute an amount within specific tenure once it was triggered by a variable. Example: 1 million of revenue will be recognized equally over 24 months once the project is completed. The 1st month of the recognition starts on the following month once the project completed…

Description of the enhancement required: In the timescale settings add Total of All Periods for Weeks: General timescale How would it help the business process: For example, looking at the travel and tourism industry, which is highly seasonal (e.g. different destinations, hotels, and services are in demand in the summer vs…

As an example, if the first month of the Fiscal Year is Mar 15, I want "May 15" returned because that's the last month of the quarter. This is my formula (on a line item formatted as Month and no Timescale): FINDITEM(Time, NAME(PERIOD(END(PARENT(TIME.'Apr 15'))))) However, this returns 'Apr 15' due to this in Anapedia:…

Description of the RFE: Users are copying and pasting formula from drilldown dialog, which isn't possible because parenthesis are removed. This is an RFE to retain the parenthesis, or at least provide that option. Use case: Drilldown formula is removing parenthesis. This is causing come issues for us working with a large…

I have an Entity list which contains the entities in my organisation. If, as the result of another calculation, I have been returned two entities in the Entity list, how do I determine their lowest common parent? Some combination of PARENT and FINDITEM seems likely... but they might be at different levels.

Hi everyone, i have a module with several line items. One line item is a List, another one is a number. After i have selected a value and entered a number, i want to link the value into a module which has the List as in the rows. Any idea how to link the data ? I would like to have the value number entered only appear on…

Since trying to follow long conditional formulas can be tricky within the Anaplan formula bar, a tip to make it easier is to use the Drilldown capability on a cell within the line item. By doing this, you're able to see the If Statement/Formula indented with each If Statement. After seeing it in Drilldown, you're able to…

Hello All - i am trying to forecast out data using actuals. I want to take the weighted average of the last three months of actual data (green box below) weighted by net auctionable (purple box below) and forecast out the rest of the year using this average. I setup a boolean row (red box below) in order to indicate which…

Hi Forum, I am new to Anaplan, this is my first post ... Set up to Demo problem: * 2 dimensdional module* Anaplan Time dimension in columms; * 2 line items in rows;* 1. Some numbers to be ranked * 2. RANK function ranking Line Item 1 Problem: RANK only returns rank 1 for all the numbers ranks, even though they are…

Is thier a way to limit the years that is available for selection when using the format line item as date?

I'm getting a circular reference while using the OFFSET function, but I don't understand why. (1) IF offset_value = -12 THEN OFFSET(Gross Revenue, -12, 0) ELSE OFFSET(Gross Revenue, -11, 0) vs. (2) OFFSET(Gross Revenue, offset_value, 0) Dimension is Months and 'offset_value' always equals either -12 or -11 based on a…

Hi, I am stuck at a point from where i am unable to proceed further. I have a module "Module 1" which has one list as page, one list as rows and columns as line items. It looks something like below PageList 1(dropdown) Line item1Line Item 2Line Item 3 (Formatted as List 1) List2 1st value List 1 value 1 List 2 2nd value…

I am trying to perform a lookup across multiple modules, but would like to avoid a gigantic case statement.I'll try to illustrate with this example. There is a list called details and a module called data. I'm trying to aggregate the data into a new module called summary. Right now, my formula is a massive conditional…

I saw the post about Find List Item based on a property, but the solution was the create a number list where the property for the Finditem was the code. We can not have it as a code, and they have similar role ups so the can not both be used as dimensions on a line item. How can I find the list item?

Hi All I have a piece of data which is based on unique keys. Each key has data for multiple months. Also there is another column which specifies the financial year. I have created an intermediate module where each transaction for a key is flattened out by month. So i have line items which derive the month value in text…

This is probably straightforward, but I'm struggling with it... I have a module that includes historical department names, which are combinations of numbers and text, i.e. "5100 Engineering". Sometimes the department names change, for example "5100 Engineering" might become "5100 Core Engineering". I want to create a list…