sorting numbers

[Former Member]

I have a group sort by workorder code; however, it's not sorting the way I'd like. It's currently sorting as follows:

19372

1946

19627

1988

19955

I'd like it to sort as follows:

1946

1988

19372

19627

19955

How to I have it recognize the workorder code as a number and sort numerically?

Thanks!

[Former Member · Accepted solution]

create a formula like this:

tonumber({table.field})

base your group on this field.

do a group sort on this group.

I hope this helps,

Regards,

Zack H.

[Former Member · Accepted solution]

Thanks Zach! However, now how to I remove the look of currency (i.e., 2,0563.00 should appear 20563)?

[Former Member · Accepted solution]

just format the formula field to the way you want it to look like

[Former Member · Accepted solution]

Forgive my ignorance, but how do I do that when the formula is not placed on the report, but in the Group Expert? I can format the Group on the report; however, I have that suppressed. I'm looking to format how the numbers appear in the Groups Preview Panel for drill-down purposes.

Thanks!

[Former Member · Accepted solution]

Why don't you just use the original field to display the correct format.

When you create a group create the group on the formula Zack gave you.

You can then under the option tab when creating a group, select another field to display what you want to see in the group preview pane.

[Former Member · Accepted solution]

Perfect -- THANKS! I'm still kinda new to CR. Appreciate the help!!!