Skip to Content
0

BO4.2 - WEBI Number format

Nov 25, 2017 at 01:31 PM

89

avatar image
Former Member

Hi All,

I am trying the below number format in Webi.

Eg: Original value = 230562.05

Webi has to display = 231

After export to excel it has to display in front end view has 231 and after click that specific cell it has to show original figure 230562.05

Note: Directly in excel I tried using this format #,##0, and working fine, but not in WEBI

Kindly advise on the same.

Regards,

R. Saravanan

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

5 Answers

AMIT KUMAR
Nov 25, 2017 at 01:46 PM
0

right click on the column-format number and define the custom format to #,##0 and try

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 25, 2017 at 04:23 PM
0

Hi,

I have done the same but no result.

Regards,

R. Saravanan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 26, 2017 at 05:33 AM
0

Hi,

Anyone done this requirement? Kindly help on this.

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Nov 27, 2017 at 09:34 AM
0

Instead of using custom format use predefined format.


untitled.png (18.1 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 27, 2017 at 03:08 PM
0

Hi Amit,

Thanks for your reply.

I have already tried and below result not getting.

Eg: Original value = 230562.05

Webi has to display = 231

Regards,

R. Saravanan

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I have tested and it's working for me.can you share the screenshot after applying the format how values are coming in webi and excel.

0