Skip to Content
0

Decimal Format

Mar 13 at 02:28 PM

20

avatar image

Hi Experts,

I need to have webi to show the decimal values until 4 digits. Could you help

Thanks,

Dinya

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

1 Answer

Best Answer
AMIT KUMAR
Mar 13 at 02:37 PM
0

right click on the column value->formatnumber->number->custom and paste "0.0000"

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

Thanks Amit Really appreciate your quick reply.

1) 214.83 ->214.8300 (wrong after applying your specified format)

2) 0.0495-> 0.0495(right after applying your specified format)

2nd value is fine as the value is alreay coming as 4 decimal places, but first value is wrong adding two more decimal.. How to apply the custom format now?

Thanks,

Dinya

0

it seems in first value there is no four decimals are maintained at database level.check in database how many decimal places are maintained.

0

Only 2 decimal places in DB sameway webi has to show as is. For 2nd value the DB has already 4 decimal but webi showed 2 decimal only, so after applying your formula it is formatted to 4 decimal places that is fine.

0

Yes, it correct in webi. bydefault it is showing 2 decimal..if you want to display more decimals places then you have to use formatnumber.

0

let me confirm with user and accept your answer Amit Thanks

0