Skip to Content
avatar image
Pan kaj

How to resolve Sorting Issue with Blank values?

Nov 08, 2017 at 02:49 PM | 75 Views

Hi All,

We have created one table in the webi report. We have several Measures and Dimensions.

Some measures have blank values in it. When I try to sort on that Measure by descending, it first shows blank values and after that Higher to Lower values. But I want blank values below lower values.

I have tried converting the blank value to Zero, but it's not working.

How to do this?

Thanks

SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    AMIT KUMAR
    Nov 08, 2017 at 02:53 PM

    add 0 in the measure and then sort.

    =[measure object]+0

    or if you do not want to show 0 in the column and create dimension variable=[measure object]+0

    drag this variable in the report & apply sort.later irght click and hide the column.

    Add comment
    10|10000 characters needed characters exceeded