Max Sales

[#1]

Hi friends,

I have some sales value interval wise,my requirement is to find max sales value for the selected interval,and if no interval is selected then the text box show max sales value from all interval,anyone please help me out.

I have attached a sample app

regards

bhawna   

[tresesco]

Well, here is the one; much more dynamic expression:

=$(='RangeMax('&Concat('Max(['&Interval&'])',',')&')')

Cheer!