Trying to calculate simple Percentage

[m3gd04]

Ok... newbie here with real bone head dillemma..

In short, I've created a report to simple show how many cases in my hospital were "late" or "ontime". I'm trying to express this as a percentage, yet in trying to do so, I keep on getting errors.


I first, created a new variable called STATUS:

it is defined as follows (shortened for simplicity sake):

= If <Description> InList ("A","B","C" etc...) And <Minutes>>0Then "Late" Else "On Time"

In my report, I want to show a simple % of whats "late" and whats "on time"

My formula for the subtotal is: =Count(<Case#>)
My formula for the total is: = =Count(<Case#>)


Here it is broken down into 2 columns and the following have been grouped by "Status" and subtotaled to show:


Status Case #:

Subtotal-> Late 140
Subtotal-> On Time 329
Total -> 469


In trying to create a variable to calculate the "On time" or "Late" %, I come up with calculation errors.

Ive tried " = if status = "On Time", then count (case#)/sum count (case#).

This should be a simple calculations, but its difficult to me. Any advice would be greatly appreciated.


thanks

 

[blom0344]

Try:

count (case#)/(sum count (case#) in (<status>))








Ties Blom
Information analyst

 

[m3gd04]

Thanks blom0344,

i tried the suggestion, yet, i'm still getting error message. I'll tweak it and let you know what I come up with. But thanks for your suggestion.....

 

[blom0344]

In a test report the following worked allright for me:

=count (case#) In (<STATUS>)/count (case#) In Block

Ties Blom
Information analyst

 

[m3gd04]

Hi Ties,

Once again, thanks so much for your help... got it to finally work...)))

 

[blom0344]

Well, you know how to mark a helpful post....

Ties Blom
Information analyst