>I am using the following expressing to prevent NaN from being displayed in
>a
> field. I am still receiving the NaN in the field. What is wrong with my
> statement?
>
> =IIF(SUM(Fields!OIL_REV_VOL.Value) <> 0,
> ROUND(Fields!OIL_REV.Value/Fields!OIL_REV_VOL.Value),2),0)

"Patrice" wrote:

> Why SUM ? Do you meant instead :
> =IIF(Fields!OIL_REV_VOL.Value <> 0,
> ROUND(Fields!OIL_REV.Value/Fields!OIL_REV_VOL.Value),2),0)
>
> For now with the expression below the SUM could be non zero and you'll still
> try to divide by zero...
>
> --
> Patrice
>
> "DONNA" <DONNA@discussions.microsoft.com> a écrit dans le message de news:
> 53BD1D19-9612-421D-B6C1-1C98C924DCD4@microsoft.com...
> >I am using the following expressing to prevent NaN from being displayed in
> >a
> > field. I am still receiving the NaN in the field. What is wrong with my
> > statement?
> >
> > =IIF(SUM(Fields!OIL_REV_VOL.Value) <> 0,
> > ROUND(Fields!OIL_REV.Value/Fields!OIL_REV_VOL.Value),2),0)
>
>