Using Dual Function with Class

[Anonymous]

I have the following calculated dimension class script:

=Left(Class(Amount, 10), FindOneOf(Class(Amount, 10), ' ',1))

& ' - ' &

(Num(Mid(Class(Amount,10), FindOneOf(Class(Amount, 10), ' ',4)))-1)

How do i incorporate the 'Dual Function' in the above script for me to be able to sort the calculated dimension as a value?

Regards.

Chris

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

=Dual(Left(Class(Amount, 10), FindOneOf(Class(Amount, 10), ' ',1)) & ' - ' &

(Num(Mid(Class(Amount,10), FindOneOf(Class(Amount, 10), ' ',4)))-1),

Left(Class(Amount, 10), FindOneOf(Class(Amount, 10), ' ',1)) &

(Num(Mid(Class(Amount,10), FindOneOf(Class(Amount, 10), ' ',4)))-1)

)

[Anonymous]

Thank you Anil