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,…
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 h…
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, th…
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 o…
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…
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 seque…
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 o…
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% / <…
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…
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 V…
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 …
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 det…
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 …
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 o…
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 cha…
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. add…
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. Cumulat…
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…
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 "Dat…
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 …
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 …
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? Thank…
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 afte…
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 …
Description of enhancement: Ability to set formula scope for selected versions rather than just the limited options of All/Actual/All except Actual/Current. Business case: This would give us the abili…
Hi Experts, I am new to ANAPLAN.Please kindly suggest me .How to solve the below requirement The Requirement is like as followes, They are three Versions 1)Actual 2)Plan 3)Forecaste. I Developed Filte…
