Portfolio Analyser Problem

[Milly]

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 because of the calculation in the formula. I need to have
#NUM! display as either 0 or as text like "No Actuals".

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

 

[scot.milroy]

Does anyone have any idea? I'm kind of desperate right now and can't
get anything to work.

Thanks,

Scot

 

[Gord Schmidt]

Try:
iif([Actual Work]=0, 0,[Work]/[Actual Work]*100)

That should do it.

Gord
--
http://www.DoMoreThanManage.com

Does anyone have any idea? I'm kind of desperate right now and can't
get anything to work.

Thanks,

Scot

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 because of the calculation in the formula. I need to have
#NUM! display as either 0 or as text like "No Actuals".

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