Portfolio Analyzer - Trapping #NUM! (division by zero) error

[Jason-W]

Hi,

I'm using MSP Server 2003. I've made a calculated field
for one of my portfolio analyzer views. One of the
calculations does division and occassionally run into a
division by zero.

My question: How do I trap division by zero? I'ld like to
have it a value of zero instead of the #NUM! error.

Thanks,
Jason

 

[JackD]

Modify your calculated field.
You can use a switch or an iif statement.

for example

iif([cost] = 0, "0", [duration]/[cost])

-Jack

 

[JackD]

Modify your calculated field.
You can use a switch or an iif statement.

for example

iif([cost] = 0, "0", [duration]/[cost])

-Jack

 

[Jason-W]

Thanks

--Jason

-----Original Message-----
Modify your calculated field.
You can use a switch or an iif statement.

for example

iif([cost] = 0, "0", [duration]/[cost])

-Jack

Hi,

I'm using MSP Server 2003. I've made a calculated field
for one of my portfolio analyzer views. One of the
calculations does division and occassionally run into a
division by zero.

My question: How do I trap division by zero? I'ld like to
have it a value of zero instead of the #NUM! error.

Thanks,
Jason

.