Calculation Functions

Hi experts, we mainatained joining date, Resigned date and last working day properties in employee dimension. Based on those properties we need to calculate previous 6 months Organization Active employees and resigned employees count. We create one module called headcount planning module.In these scenario current period is…

Hi Experts, In Employee list we maintained one property called Reporting Person. In Reporting person property we maintain reporting employee names for eg: manager reporting to owner , Supervisor reporting to manager,Staff reporting to Supervisor. In Selection When i select Owner position then Show all owner combination…

Hi experts, I have a requirement But i am cofusing acheive the requirement. In employee list we are maintaining some Properties like (Joining date,Resign date,Last working day ,Position,Employee Type, Department,Salary properties). In Employee Module, i want to get data based on page selector selection. Suppose, in page…

Hi all - I am very new to Anaplan and have just finished the Intro to Model Building. As a test for me before going into Intermediate Model Building, I tried to set up a copy of a report I currently have in Excel. The report is to show revenue by PI for each month & the % of their revenue at the site they are located. I…

Hi Experts, I am facing a unique issue, I have modified an formula on a line item with number format and it does pulls the resulted value in Dev enviornment but when the solution is migrated to QA, the formula does nothing and the line details read message as " Drill down unavailable for this cell: No other data cells are…

Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are given as a input to IRR formula in Excel it is returning a numbe

Hi Anaplan, It would be really useful and if you could format cells by logic instead of numbers directly on the cell. This could work by having blank or not blank in the formating parameters or true or false. Thanks, Usman

Hi, Anaplaners From the first table in the attached file, I would like to compare (calculate changes in values in %) first year vs second year and second year vs thrid year. The former compares sum of 2012 - 2015 (2016 should not include as 2016 for the second year is always zero) and the latter compares 2012 - 2014. Is…

In Excel, I can apply sequential numbers within each group of values. For example - Column A has groups of values which Column B applies sequence numbers to the members of each group. The number sequence in Column B is generated by COUNTIF($A$2:A2,A2) which is copied in every cell in the column. I see that Anaplan's answer…

Forgive me if this has been posted, but I did my due diligence and nothing turned up. It would be awesome if formulas had a click-able hyperlink to its source cells, similar to when you double click on a cell in excel to show a formula and it highlights the precedents. Its also similar to "Drill Down", but instead of being…

Hi Experts, Filter Module Row axis -Line Item Members- 1)Actual filter 2)Forecaste Filter 3)Budget Filter 4)Plan filter Column Axis -Time -Future 4 years 1) Actual filter applies only for actuals Version only but inthe above screenshot it applies all versions. IF Startperiod>Period(currentperiodstart()) AND…

I have a Line Item "Conversion %" in a module that applies to a fake time dimension list called "Aging Days" that ranges from 0 - 365. Module: 0 / 1 / 2 / 3 / 4 // ... // 365 Conversion% 1% / 1.5% / <blank> / <blank> / 1.6% / 1.6% / .... // 26.5% If you see the above data, it is a curve (cumulative %) over 365 days.…

Hi Everyone, I have 2 modules: The first being 'Module - Calculate' with 2 dimensions: 'Site and Services' and Time. It has 2 line items, number of days and total cost. The second 'Module - Rate Table' with 2 dimensions: 'Site' and 'Numbers'. It has 2 line items, number of days and Rate. Reason for separating the Rate…

Hi Experts, In page selector When i select Version selection.The following periods need to show remaining periods are hide Version is actual then i show previous 6 months actual periods non-editable Version is forecaste then current period to end of the with in the year data. Version is Budget then next year all periods…

Hi, It would be nice if we have the ability double clicking to open a summary line item.

Hi, I have two numbered lists, City and Product. Product has City as a property. All Products have a City as a property, and multiple Products can have the same City as a property, but not all Cities may be linked with a Product. In a module with City list as a dimension, how could I identify if a City has been linked with…

Hi, Anaplaners I have a question regarding how to create a composite hierarchy from a file where two columns alone indicate a hierarchy (parent-child relationship). Please see the attached for the detail. Is such a transformation possible ? Thank you. GregModeling

Hello, I have a module,and within it I use Time as a Page selector in it. My time is formatted like this : Calendar Type : Calendar Months/Quarters/Years, Fiscal Year Start Month: Jan, Current FY : 1 Jan 2018 - 31 Dec 2018. For a specific line item in my module I want to test something like this : IF Jun is selected THEN…

 Hi, In one module i want to read current period.Can you please suggest me what formula i use Foe suppose we are in jan-19.I want to read current Period(Jan-2019) in Filter module. Regards, Uma

Hi All, I am trying to write an formula which should plot "year" info, where it was loaded in a list. This is about dates we manually loaded in a particular year. Now i want to extract the year info on the cell where this was loaded and not the year that the date mentions. For example we loaded 31-Dec-2018 in Year "2019"…

Hi, I have a module in which few rows have blank value with changing parameter. Can i put some formula or any way in which only the rows which are non blank will be displayed irrespective of there changing parameter?

Hi everyone, I have encouterend a problem that keeps bugging me, so I would like to share this with you guys! In a model I have two timeranges: Model timerange: 2 years, months, no quarter totals. additional timerage "Long term": 5 years, quarter totals. Module A: Model timerange: Lineitem 1: timesettings: weeks Lineitem…

Hi, Anaplan is returning a circular reference eroor in the following circumstance (below are the line items - simplified); 1. Opening balance 2. Variable that depends on opening balance (1) 3. Cumulate of 2 4. Closing balance (sum of 1 & 3) - circular reference error message. Any ideas how this can be resolved? If I manage…

I'm creating a scenario model which is based on two measures. I'd like my model to only apply a specific forecasted % to a row, if the measure is "total company" and profit share measure "Construction". However, I cant use the NESTED IF function which I would use in excel as its not letting me use multiple items on the…

I have been trying to sum up the decimal numbers in "Data" column , the column "indicator" is converting individual values from "Data" column into Text whereas "Bool" is converting the Summary of "Data" into text. Can anyone provide me with an explanation why I am getting a lesser value in Bool ?

Hi, I'm using week calendar type & using 4-4-5 for week grouping into months/qtrs in the model. So whenever i used month as a time scale in a particular module and tried to use month() function, it's showing peculiar values, as shown in the attached screenshots. Can anybody tell a workaround to fix this.

Hi, I need to get the number of days spent to finish a task. What I have is "Date Start" and "Date End", currently, in excel its a simple Date End minus Date Start and it will give the number of days spent. I tried to convert date to text or number, but it doesn't convert it that way. How can I do this in Anaplan? Big…

Hi, guys What I am trying to acheive is pretty simple as in the attached file. I would like to identify a month where "sales" is maxium among "TIME" dimension(Jan 2018 to Dec 2018) Any pointers? Thanks in advance Greg

Hello, To put the problem simply, I need to know how to do the diagonal sums of an array in Anaplan. To explain in detail: I have a module called "Daily Matrix". It has the dimensions: Time, Days after Registration (a List, that "Applies to" the entire module), and one of the line items in this module is a "Daily Rate %"…

Currently MAILTO function does not work when there is a parameter (To,CC,BCC) with list formatted line item to select which email ID to select for email notifiaction. Currently either it must be text formated or hardcoded in the MAILTO formula.End user should be able to select the given list of approvers if there is a…