Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i am uploading qvw file in this file there have 2 field customer and amount
i get the minimum amount and customer name in text box but
how to get max amount customer name in textbox
you can use this..
=MaxString({<Amount = {$(=Max(Amount))}>}Customer)
you can use this..
=MaxString({<Amount = {$(=Max(Amount))}>}Customer)
Hi Vipin
1. Create one variable (Var=Max(Amount))
2. Use: MaxString(if(Amount=Var,Customer)) in your text box
Hope it helps!
Thanks,
Attitude