Friday, February 10, 2012

Calculating % totals - what approach to take?

I want to do a report as follows -
We have unique case numbers. I need to display how many cases took < 24 hours, how many cases took < 48 hours and how many took > 48 hours. As you can see, the count of cases < 24 will come in all the 3 i.e < 24, < 48 and > 48. I need to display % totals for the 3 categories.

What approach would be ideal? Any help is appreciated. I am using CR10 and SQL server as my database.First of all - the count of cases <24 will only come in 2 of the sections - <24 and <48 - it wouldn't come in at >48 b/c anything less than 24 won't ever be greater than 48.

I would make a summary field that does a running total(count) by a formula for each of the three types you want and another for the total count of all three. Then make formula fields for each one calculating the percent that way. I.E.

∑count / ∑totalcount = %

and put that in your report

Let me know if that didn't make sense

No comments:

Post a Comment