Skip to Content
0

custom numberformat in webi dhtml (BI4)

Nov 07, 2016 at 07:18 PM

83

avatar image

hi

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

thanks

regards

phil

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Kuldeep Ghosh Nov 07, 2016 at 09:16 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Ajay Gupta Nov 07, 2016 at 09:43 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Sateesh Kumar Bukkisham Nov 08, 2016 at 12:10 PM
0

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


number-format.jpg (36.9 kB)
Share
10 |10000 characters needed characters left characters exceeded