ChrisAHeathcote 
-
Re: How to map 3 columns(line items) of data to one line item based off time
If you choose to retain the current model then the best way to map these into a target module dimensioned by time is to simply SUM it into each to the years using a Year time period formatted line it…1 -
Re: SPRINT 3 Override Amount
@lcapon You do not need to use an IF statement for a simple boolean. Just state what a true result would be any other result will return a FALSE.1 -
Re: Level 3 - Sprint 1 (4.6.5) - Lookup isn't working correctly
@hinamahmood1994 Ensure that the format of the line item which informs your LOOKUP is either a time period or list. The dimension of the line item in the mapping must also be the same as the dimensio…1 -
Re: Linking Line item to List
@gaurangkoladiya Create a line item subset (LISS) from the module containing the line items. Add a new line item to module 2 but add the LISS in the applies to in addition to the other dimensions. Us…1 -
Re: Create a number sequent in a period column.
To ensure that it resets each year add another line item dimensioned by year period. Adjust the formula; RANK(1,ASCENDING,SEQUENTIAL,TRUE,Yea [Line Item])1
