count only non null values

[bhagi]

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

[rubenmarin]

Hi, I think you are looking for: =Max({<[product]={"*"}>} Year)

It will return the max year that has any value in product field.

[Chanty4u]

Hi you can try this

=Max({<Product={"<>ISNULL()"},Year=>} Year)

[Brett_Bleess]

@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