Exclude zero in average

[Former Member]

Is there a way to exclude zero values from an average?

[Former Member · Accepted solution]

Hi Mark,

If you are looking to remove the count of the records that have a zero value for your average you can do that by creating a running total. Then in the evaluate option, select formula and use something like this in your syntax:

{zerovaluerecord.field}<>0    //the operator should be not equal to, not sure why its not printing in forum.

I hope this helps,

Please let me know if I misunderstood.

Regards,

Zack H.

Edited by: Zack H on Feb 12, 2009 4:46 PM

[Former Member · Accepted solution]

I tried adding adding the code to a 'Running Total Condition Formula' and it highlighted the zero and said the remaining text was not part of the formula.

Is there any way to do this with standard summaries?

[Former Member · Accepted solution]

As per previous post Zack was trying to put the condition same as like this

not({zerovaluerecord.field}=0)

So try this in the running total to get the correct count

Regards,

Raghavendra

[Former Member · Accepted solution]

Mark,

If you do not wish to use a Running Total you can also try using a formula.

You can create a formula like the following to determine the count of records that you can use in your average.

if {zerovalue.field} ^ 0 then 1  // where ^ is the "not equal to" operator, forum not allowing operator
else 0

Then you can summarize the field however you'd like on any group or grand totals.

I hope this helps,

Regards,

Zack H.

[Former Member · Accepted solution]

FYI,

To display a less than sign, type < . To display a greater than sign, type >

So, for "not equal", type <> to display <>

HTH,

Carl

[Former Member · Accepted solution]

It sure does. Thanks Carl.

Zack H.