Hello,
I need to build a filter with yes/no values.
The yes part is conditioned by:
For the same id (CNP&SASIU) I can have multiple entries with start date(datainasg) and end date(dataoutasg).
If between 2 entries
dataoutasg(entry1) - datainasg(entry2) is 0
and
dataoutasg(entry2) - datainasg(entry2) >30,
then condition is true and the filter should show "yes", if not "No".
I am open to suggestions/solutions/opinions.
Thank you
