Change null value to "-" symbol instead of "0"

[Anonymous]

Hi, I have a question,

I have a straight table, i also have a dimension with null value.

It shown 0 in my table. I want to change the zero value using "-" symbol. I have try to change the null symbol and missing symbol on presentation tab like this:

But it didn't work.

Anybody has idea ?

Really appreciate your help. Thanks in advance.

[swuehl]

Are you talking about dimension values or expression values? Could you post a screenshot or even better a small sample QVW?

[Anonymous]

Hi,

Here is the screenshot

I use BRAND as dimension and calculate Stock using expression. Note: I'm using straight table.

Thanks

[tamilarasu]

You can try change your expression something like below,

If(Sum(Amount)=0,'-',Sum(Amount))

Or

If(Sum(Amount)=0,Null(),Sum(Amount))

[tamilarasu · Accepted solution]

If you don't want to modify your expression, you can try to change the number format like below.

Format -> #,##0;#,##0;-

[Anonymous]

Hi Tamil,

Thanks for your idea, it works well.

[kashaboinaraj]

Hi lejours

In presentation tab uncheck the supressed zero value and use  exp as if cluase  if (sum(stock),null(),sum(stock)).

[Anonymous]

Hi Tamil, just want to ask, what is the meaning of this format #,##0;#,##0;- ?

can u give me the explanation please ?

Thanks in advance

[tamilarasu]

Lejours,

Sure. Custom formats have four sections and all are divided by a semi-colon. It means that you can define a format like below:

Format        :     Positive values ; Negative values ; Zero values ; Text values

In your case:     #,##0 ;#,##0 ;-

If you want you can define a format for text values but I just ignored as you are using sum in your expression (There will be no text values). You can also try the same in excel's custom format.

Hope this helps you.

[Anonymous]

Hi Tamil,

Wow, thanks for your clear explanation.

It really helps me. Thanks once again