Problem with Calculation on Report using IIF

[pdlecesne]

I have created a report that calculates two sets of ratios. The following code is not calculating properly:



=IIf([CMINORM2YR]="0",[GPRAANORM2YR],([GPRAANORM2YR]/[CMINORM2YR]))

I am trying to get it to return the previously calculated value if the value of CMINORM2YR is a #error or 0 value. What am I doing wrong? I get #Error messages with this formula.

[pbaldy]

Try removing the quotes around 0.

[pdlecesne]

Thank-you but that did not help.

[pbaldy]

Also make sure no textbox has the same name as any of the fields in the formula.

[qa12dx]

u have null value in numeric field.
- in table prop, set the default value for the field to 0.
- run a update qry to set nulls to 0.
now ur statement will work. (remove quotation marks around numeric vals)

[pdlecesne]

Problem solved. Thanks!