Cannot set the numbers format on Vertical Percent graph

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[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)