sort order

[mart10]

I am using CR16

I have a parameter which allows user to say if they want to sort by currency or %movement. This parameter is applied to a group level which is hidden

It works fine except the sort order for %movemnt doesnt always show in order I would expect

eg it can show 1.01
2.06
22.98
5.75
6.30

I would expect it to be

1.01
2.06
5.75
6.30
22.98

The group level is defined as follows
and I think the issue is something to do with the formula where it asks me to put the %Movement in text in order for it to work

If {?SortOrder}="Currency" then {View_CurrencyPairs_v2.Ccy2} else totext({@Movement%})

 

[kray4660]

Apparently the data type of View_CurrencyPairs_v2.Ccy2 is text (Otherwise you would get an error with your If statement). Text does a different sort order than numeric. Not sure of an easy fix to this. Someone else got any ideas?

 

[lbass]

Wrap the text in tonumber().

-LB

 

[mart10]

The trouble is if I do that it falls over when trying to display by currency rather than % movement. I have a parameter called sort order you see

When I put tonumber before FXRATES_1st.ccy it doesn't like it

If {?SortOrder}= "Currency" then tonumber({FXRATES_1st.ccy}) else ({@Movement%})

 

[hilfy]

Pad the number with leading zeros and use that as the sort order, but just display the number. It might look something like this (assuming that all numbers will have 2 decimal places):

Right('000' + {@Movement%}, 6)

-Dell



Senior Manager, Data & Analytics
Protiviti

http://www.protiviti.com