-
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 -
Re: Create a number sequent in a period column.
Use RANK(1, ascending, sequential, true)1