Skip to Content
avatar image
Former Member

I CANT USE NUMBER FORMAT IN BO WEBI SAP

capture.png

Hi expert,

I cant select number format in webi bo sap.

Its possible that query desiger is sending the cell in text format.

In the screenshot you can see the problem, the funtion is not available, I cant click and personalice the cell like a number for bo the cell is a number.

Thank!!

capture.png (4.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 22, 2017 at 05:25 PM

    It seems your object type is not number.check if it is String then use tonumber function to convert string to number and after that use.

    =tonumber(object;"##")

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member AMIT KUMAR

      Data type is TEXT, but it would be number. Query designer is sending text..i think so... I cant change with =tonumber or change format with tab. But this is only happening with one query bex. With other query bex is working. I dont found the different.

      Thank you