sort order
sort order
(OP)
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%})
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%})
RE: sort order
RE: sort order
-LB
RE: sort order
When I put tonumber before FXRATES_1st.ccy it doesn't like it
If {?SortOrder}= "Currency" then tonumber({FXRATES_1st.ccy}) else ({@Movement%})
RE: sort order
Right('000' + {@Movement%}, 6)
-Dell
Senior Manager, Data & Analytics
Protiviti
www.protiviti.com