BEx Query- Making into Zero value in the blank row/column

[Former Member]

Hi All,

I am running a query on multiprovider, say I have three characteristics (sales org, distribution, customer) & key figure (amount) in the layout. I am lookling the actual & plan data in the report. If there is no plan data for the above combination of characteristics, in the report i am getting blank, instead of blank i want $0.00, how to do this?

Regards,

Anand

[sap_user62 · Accepted solution]

Hi,

Create a formula for the key figure in the columns.

Formula = 'key figure' + 0.

So you get 0 even if the value is empty

Thanks

El

[Former Member]

Hi ,

Could you please let me know how can we fix this issue.  I tried to create a new formula as KF+0 but it did not work.

Hi ,

This issue is in a Bex Query . We are looking for options on how to display blanks as zeros for keyfigures.In the below screen shot highlighted in red there is no data for march 2015 so it needs to display as zero and the overall result should be Zero.

Issue : Overall Result for Cumulative Quantity FTE should pick up the last value which is Mar 2015 instead its displaying 2 as there is no data for Mar 2015.

Thanks,

Bharathi.

[Former Member]

Hi,

Give the scaling factor of the key figure as 0.00.