Ordering by formula

[Pesket]

I am trying to order a report by a formula that is generated in crystal reports. The formula is a simple columnA/columnB converted to a string. I can leave as a number if needed to to order it correctly. I'm using version 8.0

any help would be appreciated

thanks

 

[idle]

Create another formula containing A/B, and leave it as numeric. Use this field to sort by, but don't display it on the report.
Use the formula containing A/B converted to text as the field to display on the report.

 

[Pesket]

I tried that earlier, but it doesn't seem to work, the record i'm returning is set up so:

Group Name/ column A / column B / column A/B

A and B are formulas themselves,

Is it a problem because column A/B is tied to the a group?