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
Crystal Reports
Last Comment
SStroz
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
This worked perfectly! Thank you SO much for the quick response!!!
Steve