Re: Descending number sequence with Dates (Months) as the heading
It looks good except that u hardcoded "-12" in the formula. Is there a way to not hard code it?
Assuming the parameters state that:
Start year: FY18
Launch year: FY20
That is where the users set the parameters. So the start month of Start year and Launch year is January. From that given info, how can i make the sequence without hardcording the distance between Jan 18 (being the -24) and Jan 20 (being the +1). No "0" in between the +1 and the -1 by the way.
And here's the formula for the Number line item in a module dimensioned only by time
IF ITEM(Time) < Time selection.Launch Year THEN IF ITEM(Time) = Time selection.Start Year THEN Time selection.Year difference * -1 ELSE PREVIOUS(Number) + 1 ELSE IF ITEM(Time) = Time selection.Launch Year THEN 1 ELSE PREVIOUS(Number) + 1