Divide By Zero

[Paul W Smith]

I am trying to set a calculated field which works out an average. My
problem is that sometimes the denominator is zero causing an issue. If this
is the case I would like to return a null or blank.

SumA/SumB = Average

How do I wrap my calculating code so I get my desired results?

Paul Smith

 

[Bob Barrows [MVP]]

I am trying to set a calculated field which works out an average. My
problem is that sometimes the denominator is zero causing an issue.
If this is the case I would like to return a null or blank.

SumA/SumB = Average

How do I wrap my calculating code so I get my desired results?

Use "immediate if" - iif()

Average = iif(SumB>0,SumA/SumB, 999999999 )

 

[John Spencer]

To return Null

Average = IIF(SumB>0,SumA/SumB, Null)

 

[Bob Barrows [MVP]]

Duhh! I missed " ... I would like to return a null or blank"