newbie0423
IS-IT--Management
Hello
When doing a running average or just average it there a way to exclude 0's that are in details..
I have a report that I am summing the number of rooms that are running. For every hour it either counts it as a 1 if there was a case for that hour or a 0 if there was not. At the group footer I have the sum. I would like to average that sum without including the 0's. I have tried using a running total summing the field and evaluating with a formula (see below)but this doesn't seem to be working as it returning the total and not the average. What am I doing wrong, please help. Using Crystal XI
not (
isnull({@4-5hour}) or
{@4-5hour} = 0
)
Thank you
V
When doing a running average or just average it there a way to exclude 0's that are in details..
I have a report that I am summing the number of rooms that are running. For every hour it either counts it as a 1 if there was a case for that hour or a 0 if there was not. At the group footer I have the sum. I would like to average that sum without including the 0's. I have tried using a running total summing the field and evaluating with a formula (see below)but this doesn't seem to be working as it returning the total and not the average. What am I doing wrong, please help. Using Crystal XI
not (
isnull({@4-5hour}) or
{@4-5hour} = 0
)
Thank you
V