Chart Average vs Calculated Average
Chart Average vs Calculated Average
(OP)
Hi,
I'm using Crystal Reports 2011
I calculate an average Machine Utilization based on the number of available hours vs. number of hours worked for a given time period and group it by Machine (workcenter). The calculation checks out but when I try to chart the daily utilization and average (by group) it over the date range selected the chart shows a different number than the calculated average. Anyone ever come across this problem?
If needed I can post the formulas I'm using.
Thanks for your help.
I'm using Crystal Reports 2011
I calculate an average Machine Utilization based on the number of available hours vs. number of hours worked for a given time period and group it by Machine (workcenter). The calculation checks out but when I try to chart the daily utilization and average (by group) it over the date range selected the chart shows a different number than the calculated average. Anyone ever come across this problem?
If needed I can post the formulas I'm using.
Thanks for your help.
RE: Chart Average vs Calculated Average
-LB
RE: Chart Average vs Calculated Average
What do you mean by “the daily utilization” vs. “average (by group)?”
One one hand you have HOURS (0-24) while on the other you have a percentage (0-1)?
Skip,
Just traded in my OLD subtlety...
for a NUance!
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
RE: Chart Average vs Calculated Average
I figured you'd need to see the formulas. I'll start with how I calculate the Utilization for each day.
CODE
This is total hours worked for the day
CODE
This is Workcenter capacity for the day
CODE
The chart is structured as follows:
On Change of:
Workcenter (Group1)
Show Value:
Avg of @Utilization
The calculated average is done with the formulas below:
This is Hours Worked
Sum of {@WCHoursWorkedLine}
This is Workcenter Capacity:
CODE
This is Workcenter Capacity for the day:
CODE
This is the Calculated average for the day:
CODE
Thought I should mention that Group2 is Transaction Start Date
The Chart is in the report footer.
Thanks for your help and let me know if you need any more information.
RE: Chart Average vs Calculated Average
-LB