Portfolio Analyzer formula help

[scot.milroy]

Hi,

Need a bit of help. I am using Portfolio Analyzer to display Actual
Work and Work and have added a calculated field to display the %
complete. Namely [Actual Work]/[Work]*100.

The problem is that if the Actual Work is 0 then #NUM! will be
displayed. Our senior management is on us as this looks pretty bad to
them.

I have tried several IIf statements and some nested IIf statements but
can't get anything to work.

I was trying something like:

IIf([Actual Work]=0,0,"No Actuals", IIf([Actual Work]/[Work]*100<0,0)

If someone could lend me a hand it would be greatly appreciated.
Thanks,

Scot

 

[Denis in Brisbane]

You need to avoid dividing by zero.

I'd suggest:

IIf([Work]=0,"No actuals",str([Actual Work]/[Work]*100))

It seems you can't mix text and numerical results from the If test.

I hope this works for you.

Denis