Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How can I display zero if a variable is null?

I have a WebI report in which I have a few numeric variables for which I would like to display zeroes if the value is null.  I realize can do something like this...

=If(IsNull([MyVariable]);0;[MyVariable])

Is that the only way?

I am using BO 4.0 SP4 Patch 3.

Thanks,

Noel

Tags:
Former Member replied

Hi Noel

Can we try right-clicking that numeric column,choose Format Number.

In the format number window,click on custom and enter 0 for 'undefined' box.

4 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question