Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to find the last non NULL value in a Field without any dependency on current selection
im using below expression but not working..
=Max({<[prodcut]={"<>ISNULL()"}>} Year)
thanks
bahgi
Hi, I think you are looking for: =Max({<[product]={"*"}>} Year)
It will return the max year that has any value in product field.
Hi you can try this
=Max({<Product={"<>ISNULL()"},Year=>} Year)
@bhagi yet another post where you have multiple responses, please be sure you return to your threads and use the Accept as Solution button on the post(s) that helped you resolve your issue, as this is how the posters get credit for the help they provide to the Community, and it also confirms to other members what actually worked, so please be sure you return to your posts and close them out if at all possible.
Regards,
Brett