create rankings in CR8 doesnt work

[cheerfulskeptic]

I'm using CR8 and have 2 tables - Procedures and Physicians.
The Procedure Table has a field that specifies Physician ID. I need to create a table that ranks Physicians based on how many procedures they have done. Currently I'm grouping by Physician and doing a Sort topN Group. But, I need to show certain types of procedures (say, Proceduretype field in Procedure table is set to A, B or C. I need to set the first ranking on the basis of C, but also show how they did in qty for Type A or B).
How come if I create a formula with a numbervar, it does not work and sort by that numbervar (ie, increment it in the detail section.
Thanks

 

[bdreed35]

Can you display a sample layout please?

~Brian

 

[herbsza]

Try the following.

Still group by Physician. Place the following three formula's in the detail section. Do a sum on each of the three formula's. Now you can do your ranking according to
the sum of formula procedureC and still be able to show the other totals.

formula procedureA

if {Proceduretype} = 'A' then
1
else
0

formula procedureB

if {Proceduretype} = 'B' then
1
else
0

formula procedureC

if {Proceduretype} = 'C' then
1
else
0

Hope this of some help.