Austinv 
Reactions
-
How I Built It: Creating functional P&Ls using line item subsets without COLLECT formula
Author: Austin van der Linden is a Certified Master Anaplanner and Senior Model Builder at Hubspot. Hello Anaplan Community! In this 'How I Built It' Tutorial, I show how you can build functional P&a…17 -
Re: What is difference between: ITEM & FINDITEM
Item: Returns the list item of a List formatted or Time Period formatted line item Ex. ITEM('Products') will return the item in the list to the list formatted line item FindItem: Matches a text strin…1 -
Re: Order List Action
Hi Shirisha, What you can do is create an additional line item which uses the RANK formula to assign a number to each date (see RANK formula info below) https://help.anaplan.com/anapedia/Content/Calc…2 -
Re: Calculate the difference between two dates (days/months)
Great post David. One workaround I've used to find the difference in months between 2 time periods (to @Mitch_Max point) is creating a sequential order against the time dimension using the formula be…3 -
Re: Copy data from one month of Current Year to all the months of Future Year
Hello, You can set up a System Module which sets the month you would like to allocate the values to Once this is set up, it is a simple LOOKUP to get the values to a staging line item, which can be u…3
