Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
Here is my sample data:
I want to count the records that fits the condition: Date B - Date A <= 180
I tried a number of expressions but none work:
Please help!
count(distinct {$<date[Date B] = { <=$(=<date([Date A]+180)) } >} [ID]) >>
Try:
count(if([Date B]-[Date A] <= 180, [ID])
- Marcus
This counts all records in the table.
This works perfectly! How come I didn't think of this...
Thanks a lot Marcus!
Hmmm