how to write max yoy value expression in a textbox

[kunkumnaveen]

How All,

                  I have to display max YOY increase value

to get max YOY increase value which is (67%) in 2016 i wrote below expression in text box ,but i am getting -0 value

Expression:  =num(Max(Aggr((Sum(value)-Above(Sum(value)))/Above(Sum(value)), year)),'###0')

some thing is wrong with this expression

can any suggestion plz

thanks

[avinashelite]

Above doesn't work in the text box ..that is the issue

[kunkumnaveen]

any alternative expression to get max yoy value

[RonaldDoes]

Hi Naveen,

Can you share your QVW?

[kunkumnaveen]

PFA qvw file

[kunkumnaveen]

i have attach the file

[kunkumnaveen]

Any help in writing the epression plz

[prma7799]

Please try like this in your text object

=Num(( sum({<year = {$(=max(year))} >}value) - sum({<year = {$(=max(year)-1)} >}value)) / (sum({<year = {$(=max(year)-1)} >}value))*100,'#.##')

[avinashelite]

check the attachment

[kunkumnaveen]

Thanks for your reply ,

it looks like ,that your expression  will alway take max year value only ,for the above example it gives exact output

but  in case if  YOY  value of 2015 is more then  2016 value still your expression will show 2016 value even though it has to be 2015 value ....