custom numberformat in webi dhtml (BI4)

[former_member229041]

hi

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

thanks

regards

phil

[sateesh_kumar1]

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

[CdnConnection]

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

[former_member198519]

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