cancel
Showing results for 
Search instead for 
Did you mean: 

How do I show Zero's as blanks?

Former Member
0 Kudos

I have a table chart that shows alot of zero values. I want to format these as blank. How can I do this?

Also does anyone know where I could find a extensive guide on using expression editor?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Vani

That is a very good guide thanks, Your expression you provided did not work and instead made all values blank. I will try find out how to do it with the guide you have provided.

Former Member
0 Kudos

The following formula worked, Thanks Vani.

NSTR(field, "B")

the B will display zero as blank

Former Member
0 Kudos

Hi Brad,

1. Please help me understand what is a table chart?

2. If you're referring to a table, did you try this -> in the expression editor of the respective fields, if(@field1=="0", "","")

3. Extensive guide on using expression editor : https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/visual%20...

Also, do check this: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/7bf2d990-0201-0010-a5af-e6f23a8c...

Let me know if it's helpful

Regards,

Vani