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