Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
My Data consist of ID and ACT_DT. Could anyone please help me to achieve the 'Max_ACT_Date' column. Essentially is the maxof ACT date?
I have tried max({1}Act_DT), but it give me the max of date of each row, which is ACT_DT.
Thanks.
ID | ACT_DT | max_ACT_Date |
1 | 1/02/2020 | 1/10/2020 |
2 | 1/03/2020 | 1/10/2020 |
3 | 1/04/2020 | 1/10/2020 |
4 | 1/05/2020 | 1/10/2020 |
5 | 1/06/2020 | 1/10/2020 |
6 | 1/07/2020 | 1/10/2020 |
7 | 1/08/2020 | 1/10/2020 |
8 | 1/09/2020 | 1/10/2020 |
9 | 1/10/2020 | 1/10/2020 |
so use
max({1}total Act_DT)
instead
Thank you mate.. It works like Magic 🙂