Changing line chat value to one decimal in webi

[Former Member]

Hi ALL,

SAP BO 4.1 SP1

I want to customize my line chart to show only one decimal digit in the reports

The value is a measure([%_Failure]) and it shows five decimal digits.

This what l did

On the chart l Right click >assign data> on the measure l click the drop down arrow,

but is showing only 0.0000%, l want to  customize the value to 0.0% OR 0.00%

I created a variable  =FormatNumber([%_Failure];"0.0%[%]") as a measure but can not assign it in the chat.

Any solutions

Thanks

JS

[amitrathi239 · Accepted solution]

Right click on chart->Format chart->Data Values->Percentages->Format pattern and choose the format or define your custom format.

[Former Member · Accepted solution]

Amit

Thanks for reply.

Where you doing this in Rich Client or Bi launch pad.?

Because l don't see the custom

Thanks

JS

[amitrathi239 · Accepted solution]

If you are going from BI LaunchPad then right click on the chart->Format Plot Area->Select the Value Axis->Format Pattern and select the format.

I am not using BI launch Pad, not very much idea about why custom format is not coming.

[amitrathi239]

or goto the formatchart->Value Axis->Format pattern and define the format.

[Former Member]

My environment is SAP BO 4.1 SP7