Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can you please help me to show the Max week number in text for the below, I need to display weeknumber
| WeekNumber | YearNew |
| 01 | 2019 |
| 02 | 2019 |
| 03 | 2019 |
| 04 | 2019 |
| 52 | 2018 |
Thanks,
Gowtham
Not sure I understand, but shouldn't it be just
=Max(WeekNumber)
?
Or if you want the max weeknumber of the max year
=Max({<YearNew ={$(=Max(YearNew))}>} WeekNumber)