Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to count IDs only if max(data).
For example:
IDs Data
1 29/11/2020
2 29/11/2020
3 29/11/2020
4 30/11/2020
5 30/11/2020
The result of counter is 2 because 30/11 > 29/11 and there are two ID's (4,5)
Thank you in advance.
This should work:
count({<Data = {'$(=maxstring(Data))'}>} IDs)
This should work:
count({<Data = {'$(=maxstring(Data))'}>} IDs)