Find date related to boolean line item
I have build a module with time over the columns and a flag as a line item. Now I want to extend this flag to an x amount of periods, starting from the date flagged in the current flag.
In order to do this I would like to find the date attached to the TRUE value of the flag, then sum the amount of periods to this date, and then create another flag. How can this be done?
Best Answer
-
What is the logic for determining the initial Wave period?
If this is a date and held outside of that module (i.e. one not by time), then you can use the ADDMONTHS() function to add the amortisation period (10) to the date which will then give you the "end date".
You can then build the logic for checking between the "start" and "end" dates
Details of the function are here:
https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ADDMONTHS.html
I hope this helps
David
0
Answers
-
Hi
Can you include a mock up or screenshot?
It's a little tricky to understand exactly the requirement
David
0 -
The row 'Wave date' should be extended over 10 periods, starting from the current selection, so Oct 15 - Aug 16 are highlighted at the end.
0 -
Sorry, still a little confused. what determines the 10 periods?
0 -
The 10 periods is determined by the 'Amortisation period - months' line.
0