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

Cannot set the numbers format on Vertical Percent graph

Hi experts,

I have an issue setting the numbers format on a stacked bars graph

On the X axis there's only 1 dimension

On the Y axis there are 3 ratios. On two of them the number must be separated by commas ##,### . The other one is a percent #,##0[%]%

When trying to format the number while on Structure view, it just doesn't apply any of the numeric formats.

When looking on the propierties (Data > Y axis > Values ) there is no option for number format.

The image of the graph is attached. I'm using WebI 3.1

Is there something I can do on this case? or it's just an unresolved bug?

Thanks!

LH

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2012 at 08:42 AM

    Hi,

    Apply your formatting (varsample= FormatNumber([Object];"#,###") ) for the object and use that variable in the place where you use the Oject.

    Else Before Turning to Chart format your object in the table and then turn to chart.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Kiruthika,

      I tried both.

      With the FormatNumber formula, the varsample is fine, but it doesn't allow me to add it into the chart. A "prohibited" icon appears.

      If I apply the formula directly, my ratio dissapears from the chart. I used:

      = FormatNumber([Measure];"#,##0.#0")

      = FormatNumber([Measure];"#,###")

      If I create a table with the correct numbers format, it is fine. When turning it into the Vertical Percent Chart, the format dissapears.

      Any other ideas?

      The BOBJ version is BOXI 3.1 SP5 (12.5.0.1190)

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2012 at 03:47 AM

    HI,

    Clariffy what is the Datatype of Ratio..If is number, apply format as #,##0 on Secondary Y-Axis.

    You can do this from Properties tab of Yaxis.

    Please give a try. If it doesnt allow, make a variable using FormatNumber(Object;###0).

    If it doent work convert it to Tonumber and then apply fromat

    Hope this helps...

    Thanks

    Jagadish

    Add a comment
    10|10000 characters needed characters exceeded

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.