SStroz
asked on
Sorting a Group by a formula result
Gurus,
I'm having some trouble. I have a report where I'm analyzing transactions (this year revenue vs. last year revenue) by physician/company and then calculating a "variance" formula that simply subtracts last year from this year and displays a result in a Group.
The problem is the client wants to see a report "sorted" by the Variance field (and Crystal hasn't calculated it yet).
Any ideas? I've attached the report in case you need to look.
Thanks in advance!
Experts-Exchange---Sort-by-Variance.rpt
I'm having some trouble. I have a report where I'm analyzing transactions (this year revenue vs. last year revenue) by physician/company and then calculating a "variance" formula that simply subtracts last year from this year and displays a result in a Group.
The problem is the client wants to see a report "sorted" by the Variance field (and Crystal hasn't calculated it yet).
Any ideas? I've attached the report in case you need to look.
Thanks in advance!
Experts-Exchange---Sort-by-Variance.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This worked perfectly! Thank you SO much for the quick response!!!
Steve