Summary / Running Total Field could not be Created...

[cmpgeek]

here is my problem guys...
this is the first part of my report - it is pretty self explanatory...


OR 1
day # of minutes minutes utilization
cases used avail. percentages
--------------------------------------------
MON 14 937 6630 18%

TUE 22 1186 6120 27%

WED 33 1695 6120 38%

THU 19 1021 6630 21%

FRI 16 943 6630 19%

next what i need to do is add all the averages together (which of course are from a formula) and then divide by 5 to get the roooms overall average for Mon - Fri

all i could think of trying is this:
sum({@utilwithTO}, {CASE.CAS_ROOM}) and then dividing that total by 5; but everytime i try it i get
"the summary / running total field cannot be created"...

does any one have any suggestions...

*ultimately i am also going to need to add all the Mon-Fri averages up and divide that by the number of rooms to get our overall O.R. utilization...

thanks for your brain power...

ShannonLea

 

[Ngolem]

@utilwithTO formula probably has a "whilePrintingRecords" statement in it...remove this line

Jim Broadbent

 

[IdoMillet]

Crystal can't aggregate aggregates.

Use variable instead: Increment them in the Group footer and use the final value of each variable in a formula in the report footer.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[cmpgeek]

Ngolem - there is no WhilePrintingRecords statement in the @utilwithTO formula... the evaluation times is another area where i am serious lacking... ironically the area that intimidates me the most is variables... someone here helped me with them once; but i use them so rarely that i am back to square one with them - which is why i can not grasp your explination Ido...

i appreciate yalls help anyway... thanks

ShannonLea

 

[IdoMillet]

In Group Footer for Day of Week (DOW) place a formula:
----------------
NumberVar CUM_Avg_Cases;
CUM_Avg_Cases := CUM_Avg_Cases + {@Your_Average_Cases_Per_DOW_Formula};
----------------

In Report Footer place a formula:
----------------
NumberVar N_Cases;
CUM_Avg_Cases/5
----------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[IdoMillet]

That should be:

In Group Footer for Day of Week (DOW) place a formula:
----------------
NumberVar CUM_Avg_Cases;
CUM_Avg_Cases := CUM_Avg_Cases + {@Your_Average_Cases_Per_DOW_Formula};
----------------

In Report Footer place a formula:
----------------
NumberVar CUM_Avg_Cases;
CUM_Avg_Cases/5
----------------


CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Ngolem]

Actually I don't think that is a proper average...taking an average of average is not correct

for example

item 1 possible average

10 100 10%
1 50 2%
-- --- ---
total 11 150 7.3% not 6%

Your formula for averages is much more complicated than this but you can see from this example that an average of an average is not correct.

Variables are not that hard to work with. Post your formula for the average and we shall see how to work with it.

Jim Broadbent

 

[REMill]

Shannon,
Obviously, the number of procedures performed is not important in the O.R. Utilization percent, only the 'Available' vs the 'Actual use plus Turnover time'. Shouldn't your percent for Monday be 14%?

If you have multiple facilities, do a first grouping on Facility, then a Sum on both your 'Usage' and 'Available' fields.

Your formula should be (Used Min / Avail Mins) times 100 (to move the decimal), then format to show only the whole number percent.

This would apply equally to the DOW grouping and to the Facility (or Grand Total) grouping.

 

[cmpgeek]

Remill - what you dont see in those numbers is the turnover time... that is a different field, and i had not even realized i had left it off when i posted this; but thank you for bringing that up...

Ngolem - that YOU for bringing up the descrepancy of averaging an average... when i was showing the first draft to my boss that is what she did to get the numbers; so i didnt even question it... i tried it with a couple rooms this morning and it does make a difference...

my formula for the average is:
(({@total} + {@turnover})) / {@availabletime} * 100

what i ended up doing was totaling up each column and doing a seperate % on that... sometimes i think my brain gets stuck in reverse... sorry i bothered yall with this one...

ShannonLea