S
scot.milroy
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
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