How to sort my straight Table Total Amount Column from hi to lo ?

[paulyeo11]

Hi All

I have a Table with the expression from Ram :-

'S$ ' & Num(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *Num(

sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)

,'###,##0.00'),'###,##0.00')

I need the Total Amount to sort from hi to lo .

Hope some one can advise me.

Paul

[paulyeo11]

my QVW

[paulyeo11]

Hi All

I have found a solution , that is create a column with out currency sign and i sort in that column . and hide it , it work fine , thank you

Paul

[Anil_Babu_Samineni]

NP, Close this thread