Decimal Format

[former_member402770]

Hi Experts,

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

Thanks,

Dinya

[amitrathi239 · Accepted solution]

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

[former_member402770 · Accepted solution]

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

[amitrathi239 · Accepted solution]

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

[former_member402770 · Accepted solution]

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.

[amitrathi239 · Accepted solution]

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.

[former_member402770 · Accepted solution]

let me confirm with user and accept your answer Amit Thanks