cancel
Showing results for 
Search instead for 
Did you mean: 

Format Number in WEbi

abhimanyu_sharma
Contributor
0 Kudos

Hi Experts,

I want to show values of the column "Stock on Hand" upto 2 decimal places.

Example :

SOH          SOH- required

6000                    6000.00    

2000.1                  2000.10         

13.6                       13.60

How could we achieve this in Webi?

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Abhi,

=formatnumber(SOH;"0000.00")

or the below format.

Answers (2)

Answers (2)

Former Member

Hi Abhi,

you can show the decimals by using below formula as well,

=FormatNumber([SOH];"00000000.00")

Regards,

Samatha B

Former Member
0 Kudos

Hi Abhi,

You can give your own custom format see below steps.

step 2

step 3