Highlighted
Occasional Contributor

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?

5 REPLIES
Expert

Re: Find date related to boolean line item

Hi

Can you include a mock up or screenshot?

It's a little tricky to understand exactly the requirement

David

Occasional Contributor

Re: Find date related to boolean line item

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.

Expert

Re: Find date related to boolean line item

Sorry, still a little confused.  what determines the 10 periods?

Occasional Contributor

Re: Find date related to boolean line item

The 10 periods is determined by the 'Amortisation period - months' line.

Expert

Re: Find date related to boolean line item

 

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