Skip to Content
author's profile photo Former Member
Former Member

Number Formatting in Webi Report

Hi Webi Experts!

I'm struggling here with number formatting:

I have a value in report: 234,764,97

instead I want to have: 234.765

and negative balances have to be in parentheses:

is: - 234,764,97

expected: (234.765)

there is not standard definition for the requirements I have, so I need to write a formula,and trying this:

=ToNumber(FormatNumber([Value];"##.####"))

but the result is not what I want..

Can anyone assist?

Many thanks!

Irina

P.S. if the question was already raised and answered, just give me a link, I couldnt find exactly the same question.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2013 at 10:37 AM

    I could fix it by using custom function and modifying/creating new custom format the most appropriate number format.

    KR,

    Irina

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 21, 2013 at 04:26 PM

    Hi Irina,

    the thousands and decimal separators come from the localization settings in the preferences, you can't alter them.

    For what concerns the parentheses for negative values this can be done with right click, format number

    Thanks and regards,

    Simone

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Irina,

      if you right click on the cell then you can select from the pop up menu Format Cell, from there you can customize the format for Positive Negative and Zero, Undefined values.

      Have a look and do some testing, apart from the above limitations you should be able to get to the format you need.

      Cheers

      Simone

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.