Skip to Content

custom numberformat in webi dhtml (BI4)

hi

how is it possible to add a new number format in numberformat list in webi dhtml

thanks

regards

phil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 07, 2016 at 09:16 PM

    Well you can try creating a function using a document for BO XI 3.1.

    https://help.sap.com/businessobject/product_guides/boexir31SP2/en/xi31_sp2_webi_calc_ext_en.pdf

    There are some thread which suggests it has been tried but they fail to get the dll registered. This is one such example

    https://archive.sap.com/discussions/thread/3873044

    Having said that there is already a suggestion been made on Ideas.sap.com to have a feature for custom function as we have for Crystal Reports. You can also vote for the idea.

    https://ideas.sap.com/D26565

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 07, 2016 at 09:43 PM

    Phil,

    You have a couple of options:

    - You can create the custom format within the WebI document, the user will be able to use this custom format within other tabs

    - You can also create a staring WebI document with the custom format

    Regards,

    Ajay

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2016 at 12:10 PM

    Hi ,

    what you are referring to ?

    you can have static formatting using formatnumber() like formatnumber([Keyfigure],"##")

    or

    you can make dynamic formatting by using input controls to define your format manually runtime .

    create a new variable , type in your default number formatting .

    V_Format ="#"

    in columns, use =formatnumber([Keyfigure];[V_Format]) .

    select V_Format as input control "Entry Field" or define certain formats you want to provide to users .

    number-format.jpg

    Thanks

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded