how to get max,min volume

[kunkumnaveen]

Hello All ,

               From the below table how to get these column

For

       MAX VOLUME= sum(MAX OF NUMBERS VOLUME) which is (045)  (-52+57)=5

       Min VOLUME= sum(MinOF NUMBERS VOLUME) which is (007)  (-5)=-5

But I need it in column wise as below

thanks

[shraddha_g]

Try:

sum({<NUMBER = {"$(=max(NUMBER))"}>} VOLUME)

sum({<NUMBER = {"$(=min(NUMBER))"}>} VOLUME)

[kunkumnaveen]

Thanks for quick reply ,but for some reason I am getting 0 as output when I  am using min volume expression

[shraddha_g]

you are getting output for Max Expression?

[kunkumnaveen]

No I am getting either of them

[kunkumnaveen]

Sorry I am not getting either of them

[shraddha_g]

can you share sample app?

[kunkumnaveen]

Any More Suggestion regarding the above requirement plz