whats wrong with this?

[#1]

Hello Experts,

Whats wrong with the below expression here???

I am trying to get the maximum of the date_value when i select year dimension and then show the sales... year and month are generated from date_value field which is in dd/mm/yyyy 00:00:00 format..

=sum({$<year = {'$(=max(date_value))'}>}reportValue)

Thanks,

Mady

[swuehl]

Hi Mady,

please note that your current selection is still valid, because aof the first $ in your set expression.

If you select one date, you only get the value of that date.

Try, 1 instead of $ for full year sum.

Stefan

[swuehl]

I think this should work:

=sum({1<year = {$(=year(max(date_Value)))}>}reportValue)

(removed the '' and added year() function)

Stefan

[#4]

No use Stefan, please check the other discussion I have updated...