Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Average of non zero values 1
- Thread starter RichGK
- Start date
-
1
- #2
You'll have to use a formula to create the number to divide by and another formula to do your average.
The first formula will look something like this (I'll call it {@NonZero}:
If IsNull({table.value}) or {table.value} = 0 the 0 else 1
The second will look something like this:
if sum({@NonZero}) > 0 then
sum({table.value})/sum({@NonZero})
else 0
This does the average for the report as a whole. If you need to do it for a group, you'll format the sums like this:
sum(value, group field)
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.
The first formula will look something like this (I'll call it {@NonZero}:
If IsNull({table.value}) or {table.value} = 0 the 0 else 1
The second will look something like this:
if sum({@NonZero}) > 0 then
sum({table.value})/sum({@NonZero})
else 0
This does the average for the report as a whole. If you need to do it for a group, you'll format the sums like this:
sum(value, group field)
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question