Skip to Content
avatar image
Former Member

Number Formatting in Webi Report BO 4.0

Hello Webi Experts,

I am struggling with number formatting in WebI report. I am using BO 4.0 SP9. I want to display number with one decimal point so I used custom format #,###.# . But If my value is 0.9 , it is truncating 0 (zero) and showing only .9.

Please advise how to show leading zero in report as well as in Excel sheet. Also this custom formatting is showing point(.) after zero like 1., 0. in excel sheet.

Any help would be much appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • May 28, 2015 at 01:02 PM

    Hi,

    Use the below formula

    = formatnumber([Field];"0.0")

    Thanks,

    Tanveer.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2015 at 12:24 PM

    you can try following formula:

    = FormatNumber(measure;"00.0#,###")

    Thanks,

    Swapnil


    Add comment
    10|10000 characters needed characters exceeded

  • May 28, 2015 at 01:18 PM

    Hi,

    In Format Number->custom-> type 0.0 for positive cell and also for undefined cell and click add.

    Hope it helps...!!

    Grtz

    -Anila.

    Add comment
    10|10000 characters needed characters exceeded