we have Excel Match formulas which looks thru a lookup_array 1) which finds the largest value that is less than or equal to lookup value (match type 1) and 2) which finds the smallest value that is gr…
Hi, We have a customer who have an alternative week description, their year runs from March to March, so their week 1 is ANAPLAN's week 9 for example. I have created a list 'Weeks' and this has the 'R…
Hello Anaplaners, I have an issue about displaying YTD and YTG in columns. In a dashboard, i display a module with native time in columns. On this module, we set up a boolean dynamic filter linked to …
Hi Everyone, Is there any way to set up a rolling 18-Months in Anaplan, as time dimension? Right now we are able to set up 2 full fiscal years, to get 18-Months for forecasting. But at the 7th month o…
hi all, Can we get an item value from one module to another module for a particular item . Ex: Module1 | Sales | Rebate A | 10 | 2 B | 20 | 4 C | 30 | 6 In Module2 for the "C2" attribute for the item …
Need to establish the number of days between a given future date and today's date. It's currently a pre-requisite for a set of business rules to kick in. Haven't had any luck in finding a DATE functio…
Hi, Anplan friends, May I have pointers how to get current fiscal year as NUMBER ? For example, In case where "Fiscal Year Start Month" is April and "Current Period" is March 2019, I would like to hav…
Hi All, I have a number of versions in my model with different switchover date. I also have ranking function on the last date prior to Switchover. For instance, I set the swithcover to Aug 17 then I n…
In attached image i'm trying to get the highlighted GREEN of second column cell value into highlighted BLUE of first column cell. What formula needs to write to achieve this ? Thanks, Satish.
Hi, Anaplan Friends, I have been faced with a difficulty in getting a value from previous FY where FY is not time dimention, but a list member. Please refer to the attached file for reference. Here I …
I am working on seeding a line item from one module into another module. The action only seems to work when the Versions setting is set to Not Applicable. However, then our module (under the Not Appl…
Hey Anaplaners, so my need is to create a formula that will go through the line item, that has a monthly timescale (that line item is filled in as numbers by the user) and return first month \ date (d…
Hi all, I'm working on a model which has a month format in my time dimension, this is nessecary because of workspace restrictions. But there is a need to add FTE using a begin and end week, so I've co…
Hi, Anaplan friends I have faced with a problem in calculating ratio in a nested axis. Please see the attached file for what I have now and what I would like to have. I have lists "Sales Region" and "…
Dear Experts, We are creating line item subset from multiple modules. Each of these modules have a different dimensionality. Example: First source module has ENTITY, DEPARTMENT with standard TIME & VE…
Fellow Anaplanners, We have a summary module in our Headcount planning application which pulls from both the new and existing headcount module. The new headcount uses a numbered list, existing headcou…
I have 2 modules one is for performing calculations the other is to report on the calculation results. The line items in the calc module align with a list, not a line item subset, that the reporting m…
Need help on Rank function from Anapedia Result = RANK(Source, Direction, Ties, Include, Group) I have 2 group parameters for rank function (Parent(Product) and Parent(office)) but don't know how to i…
Hi Is there any way or function to calculate inventory catch up date? i want to calculate 1st date that recover the sales plan. Jul 01Jul 02Jul 03Jul 04Jul 05Jul 06Jul 07Jul 08Sales 20 10 Production 1…
Hi, I am a beginner in Anaplan. I created five lists which have 'currency' in its property tab for organization hierarchy. (LV1 though LV5 and LV5 is the most detailed list) I noticed that LV3 'curren…
I'm trying to write a formula in the module 'Spend (FY18)', that refers 'Budget (FY18)'. I want the formula to check the column 'Period' (which is a pick-list of four options) and if that period equal…
Since the current NPV formula in Anaplan is similar to Excel's XNPV, Anaplan NPV results can fail to match Excel NPV results. This situation can lead to a lack of confidence in Anaplan's calculations …
Hello All, This is my issue: - I have a module called "Billings" where I have my billings by version (version A, version B and version C) - I would like the end user to select a version (A, B or C) - …
I have one module containing of data from January 2010 to December 2020. In another module my dimension is not the Time period but a defined list of months. In these 12 columns of the second module, I…
I am trying to pull apart the components of a profile function so I can understand the impact of a certain period. Example - I have a ratable revenue recognition treatment for my bookings and I would …
Hi team, I got a problem with a switchover when I can not replace the last period on the time scale with an actual version. I have two versions: Plan and Actual for one-year timescale Jul'16-Jun'17. I…
Hi, 'Infinity' has been returned as the result of MIN function as the attached screenshot. What should I do so that Zero value can be shown instead of 'Infinity'? Best regards, Maki Yasuda
