How to deselect dynamic data?
for the set of data selected, I want to deselect records that are marked as 'HAPPY-PATH' and 'NOT IN MY INVENTORY' only for the latest date.
How to write an action for this?
selection <> max(CONTROL_MON) & '|' "*HAPPY-PATH*"
or selection <> max(CONTROL_MON) & '|' "*NOT IN MY INVENTORY*"
I have data like below. Here max(CONTROL_MON) is 01/12/2019. The below highlighted record should be excluded from the selection.
CONTROL_MON | KEY_LINK | CATEGORY | SUB_CATEGORY | CONCAT |
01/12/2019 | 1 | EXCEPTION | EXCEPTION | 01/12/2019EXCEPTION |
01/11/2019 | 1 | EXCEPTION | EXCEPTION | 01/11/2019EXCEPTION |
01/10/2019 | 1 | EXCEPTION | EXCEPTION | 01/10/2019EXCEPTION |
01/12/2019 | 2 | HAPPY-PATH | EXCEPTION | 01/12/2019HAPPY-PATH |
01/11/2019 | 2 | NOT IN MY INVENTORY | EXCEPTION | 01/12/2019HAPPY-PATH |
01/10/2019 | 2 | HAPPY-PATH | EXCEPTION | 01/10/2019HAPPY-PATH |