Sorting a group on a formula field

[jonesanne]

I need to sort data in a group footer based on the following formula field:

If Sum ({@casetotal}, {JOINALLSales Journal.CustomerID})=0
Then 0
Else (Sum ({@netrevenue}, {JOINALLSales Journal.CustomerID}))/Sum ({@casetotal}, {JOINALLSales Journal.CustomerID})

Is this possible?

Many thanks,
Anne Jones

 

[chelseatech]

You won't be able to TopN or sort by that, but you can create the appearance of that by using one of the two totals.

Sum ({@netrevenue}, {JOINALLSales Journal.CustomerID})
will work if they all have similar case totals, but I'd probably prefer to use

Sum ({@casetotal}, {JOINALLSales Journal.CustomerID})

And set it to Descending sort
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm