Blank space instead of zero in query Key field.

[Former Member]

Hi Experts,

i have requirement that populate Blank space where ever my key values are coming as zero in Bex query report output.

Can any one help me on this please.

Thanks,

satish

[former_member220624 · Accepted solution]

Hi,

If you want to display space for the keyfigure value 0 then you can use this query property:

Go to query properties:---Value display---Zero value display---then select Zero as space.

Note:This function will be applicable for all the keyfigures in which value is 0.

You can also try with a formula.

The formula would look something like this (KF1 > 0)*KF1

Regards,

Amit

[Former Member · Accepted solution]

Hi Amit,

The below setting is working fine for me.But as i have to put this setting only on one Key figure.

Go to query properties:---Value display---Zero value display---then select Zero as space.

But the below Formula is not working, it is giving zero only.

(KF1 > 0)*KF1.

is there any other way to get this.i mean for one KPI.

Thanks,

Satish Pattanayak

[former_member220624 · Accepted solution]

Hi Satish,

Ok since it's not working for one KPI you can achieve this by change in the way you populate this key-figure in the underlying data-provider.

You can write a routine which checks if the value is '0' then populate it as blank and then use it in BEx.

I am not sure if this can be directly achieved in BEx for one KPI.

Regards,

Amit