Access 2010 calculation in table resulting in #NUM!

[jlr123]

My calculation for % is resulting in #NUM! and I need for it to result in 0% if the calculation results in 0. This (I hope) will enable me to group and get an average % in a report. Does anyone know how I can do this?
Thanks.

 

[dhookom]

You really need to provide some significant information about your data, field types, expressions, control sources, etc.

Duane
Hook'D on Access
MS Access MVP

 

[jlr123]

This is in my table.

(Currency) (Currency)
Expression : [Total job Expenses]/[InvoiceTotal]
Result Type: Single
Format: Percent
Decimal Places: auto

 

[dhookom]

Is this expression actually in the table design?
Is it possible one or both fields are blank or 0?
You may need to change the expression to: IIf([InvoiceTotal]=0,Null,[Total Job Expenses]/[InvoiceTotal])


Duane
Hook'D on Access
MS Access MVP

 

[jlr123]

This worked perfectly. Thanks very muich.