PrevContributor 
-
Re: using Parent and Item
thanks - yes, I'd tried formatting to ProductsL2, and entering Prd_parent=parent(item(ProductsL3)) - but still got the invalid formula message. However, after much trial and error, I discovered …1 -
Re: Prior Year on Weekly Module
Hi Simon Could it be the solution - when you compare values using start date for target week? E.g. you calc on week timescale lineitem date was year ago = start()-365 then you use formula=source_line…1 -
Re: Year over Year Growth
I guess the easiest thing is to set up a new line item for 'Prior Year Revenue' which is OFFSET(Revenue,-4,1) ... (or could be POST(Revenue,4). And then have Growth = (Revenue/Prior Year Re…1 -
Re: Line Item Reference Syntax by Dimension
Hi Luke - From your description, I assume you have Team as a list, and a module where you have GL data by team. If that's the case then the easiest way is with a SELECT function, i.e. Sales - Te…1 -
Re: Decumulation of vakuations
Development is underway to provide enhanced accumulation functions within Anaplan. These should provide the ability to accumulate on any List (based on the display order of items within the list) and…1
