Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 07, 2011 at 08:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2011 at 08:36 PM

    Hi,

    Give the scaling factor of the key figure as 0.00.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 07, 2015 at 07:02 PM

    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.

    Inline image 1

    Thanks,

    Bharathi.

    Add comment
    10|10000 characters needed characters exceeded