cancel
Showing results for 
Search instead for 
Did you mean: 

How can I sort by a formula

Former Member
0 Kudos

I want to sort my grouped results by one of the formula fields. Ex. I have a list of clients- the formula field is a percentage of amounts billed versus amounts collected for the group. I would like to sort in ascending order the calculated percent for each group summary to see with ones had the worst collection rate first. When I choose group sort order, the formula I created is not an option, only the group summary fields.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Just add the formula to the Record Sort Expert in CR, the same way you would with any other field.

Former Member
0 Kudos

the formula is not an option to choose from when you are sorting the groups. I would like to sort the groups by then formula I have entered.

Former Member
0 Kudos

No, but it is available in the Record Sort Expert.

Answers (0)