Rank Function

[#1]

Hi,

I have attached the samle QVW with the sample. Please could you have a look and advise.

I trying to calculate the 'Quartile Function' , i.e '(No of Rows + 1 ) /4 '

When I do No of rows I get '17' and after doing the calculation it will be 5.

I want to get the value '500' which is against the value '5'

Thanks,

Sijo

[#2 · Accepted solution]

You can use min function instead of rank to get the desired out out.

something like this...  Min(Amount,<your number>)

e.g: Min(Amount, 5)

[#3]

Thanks