Zeros for null data

[system]

For months with no sales, I would like to see a zero in my results rather than a blank. Is there a way to turn this on?

---

cherij (BOB member since 2006-08-10)

[system]

You can use either an alerter, or an If statement (e.g., =If(IsNull([object]) then 0 else [object]))

---

sredden1 (BOB member since 2011-06-09)

[system]

Hi,

It’s been discussed just yesterday:

120×120 10.4 KB

Hi All, in boxi rel 3.1 is there a webi setting which turns numeric fields from nulls to zeros? Thanks Bell_33 (BOB member since 2010-07-05)

Have you tried searching the forum before posting?

---

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

[system]

Yeah, actually I did search for my topic under Web Intelligence XI and nothing came up. Maybe you should try the search before making snide remarks.

---

cherij (BOB member since 2006-08-10)

[system]

@cherij

Maybe you should try the search before making snide remarks.

Yes. I tried. Searching in the WebIntelligence XI forum with the keywords “zero” and “null” found me also the topic that I linked to.

Asking members to use search before posting is not a snide remark.

---

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

[system]

Just add a zero to the formula:

=[Metric]+0

---

Hafsolace (BOB member since 2010-08-27)

[system]

@Hafsolace

Just add a zero to the formula:

=[Metric]+0

Excellent hint, seems to work! 8)

---

triangulum (BOB member since 2011-10-21)