Fomula Error

building reports desktopintelligence
1

Hi Guys, I am currently building a reports and requires me to use the formula:

=If Iserror (<# measure>/<# measure>) Then “” Else (<# measure>/<# measure>)

Is my formula correct? I would like the cells with no values be blank and not NA or any other value.

Thanks a lot guys.

bi-bo (BOB member since 2009-12-11)

2

It should be

=If Iserror (<# measure>/<# measure>) Then 0 Else (<# measure>/<# measure>)

Then use format cell > number and use a space for equal to zero box
.

haider :es: (BOB member since 2005-07-18)

3

Or try using a formula like this:

=If Not(Iserror (<# measure>/<# measure>) ) Then (<# measure>/<# measure>)

Marek Chladny :slovakia: (BOB member since 2003-11-27)

4

Hi Guys, thanks! Both formula worked. :smiley:
Thank you very much.

bi-bo (BOB member since 2009-12-11)