ChrisAHeathcote 
-
Re: SUM function usage on different dimensionality
The SUM and LOOKUP formulas are used to map dimensions between modules where a direct link does not exist. Therefore, in order to successfully reproduce the formula in other modules it must contain e…2 -
Re: Import error (parent item has a child item that is in a different list)
Have you tried using a numbered list? If so, and the error persists it would appear that you are trying to create a parallel hierarchy. Create a duplicate second hierarchy using the desired parents a…2 -
Re: Formula Assistance
First impression here is that you formula is far to long. Break out your formula across more line items. Secondly, you are using hard coded numbers which really should be coming from an input module …2 -
Re: Line Item Formatting
You are correct. I was not aware of formula scope and its range of functionality. I have managed to resolve the issue using formula scope to display actual and capture forecast in the same module.2 -
Re: Calculation within the list
Hi @Vladimir Using a mapping and LOOKUP function is the only approach that will allow you to reference a different item within the same list. When setting up the items in your list use a number refer…2
