Non Zero Formula

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I have a report that has a field =[Target]/[TotalErrors]

I want if Target equals a positive # and total Errors equals 0 1000% is
returned.

How do I change my field to capture this. Currently I am returned in error
if this occurs.
 
=IIF([TotalErrors]=0,10,[Target]/[TotalErrors])

I have a report that has a field =[Target]/[TotalErrors]

I want if Target equals a positive # and total Errors equals 0 1000% is
returned.

How do I change my field to capture this. Currently I am returned in error
if this occurs.
Click to expand...
 
=IIF([TotalErrors] <> 0,[Target]/[TotalErrors],10)

this presumes that your field is formatted as Percent. 10 will then give you
1000%.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top