nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

rounding decimal number

mh10

Hi,
i have one computed column which has values in format
12.987897456276954

i want to display them on pie chart, with 2 decemal rounding to

12.99

Any suggestions?

Thanks

Find more posts tagged with

Comments

bhanley

Hi. Sample attached which does this. Here is what I did:

1) Build out the data set
2) Create the Pie Chart
3) On the Format Chart tab of the Wizard, click on "Value Series" Then click the "Labels" button.
4) On the label configuration window, click on "Value Series" and then click the format button (a small Button right below the values selection box).
5) Format the label however you want. I chose "Standard" with a $ prefix and two decimal spots.

I also configured a tool tip to be dynamically added to this chart as well when you hover over a slice of the pir. Click the "Interactivity" button to have a look at that.

Good Luck!

mh10

Thanks bhanley........it worked 
 
<blockquote class='ipsBlockquote' data-author="bhanley">Hi. Sample attached which does this. Here is what I did: 
 
1) Build out the data set 
2) Create the Pie Chart 
3) On the Format Chart tab of the Wizard, click on "Value Series" Then click the "Labels" button. 
4) On the label configuration window, click on "Value Series" and then click the format button (a small Button right below the values selection box). 
5) Format the label however you want. I chose "Standard" with a $ prefix and two decimal spots. 
 
I also configured a tool tip to be dynamically added to this chart as well when you hover over a slice of the pir. Click the "Interactivity" button to have a look at that. 
 
Good Luck!</blockquote>

mh10

how can i do this using any expression or any math function? 
from 12.347234645 to 12.35 
 
i tried Math.round(value * 100/ 100). but it is giving me whole number i.e 12 
 
 
Any suggestions? 
 
 
Thanks 
 
<blockquote class='ipsBlockquote' data-author="bhanley">Hi. Sample attached which does this. Here is what I did: 
 
1) Build out the data set 
2) Create the Pie Chart 
3) On the Format Chart tab of the Wizard, click on "Value Series" Then click the "Labels" button. 
4) On the label configuration window, click on "Value Series" and then click the format button (a small Button right below the values selection box). 
5) Format the label however you want. I chose "Standard" with a $ prefix and two decimal spots. 
 
I also configured a tool tip to be dynamically added to this chart as well when you hover over a slice of the pir. Click the "Interactivity" button to have a look at that. 
 
Good Luck!</blockquote>

bhanley

What context are you trying to alter the display. It is a different process (only slightly) for Charts, tables and text objects.

mh10

Hi bhanley, 
I am trying to display these rounded numbers on Pie chart. 
 
Col1 ----> Col2 (computed ) 
 
12.13642314 ---> 12.14 
10.24354355 ---> 10.24 
7.1234312 ---> 7.12 
3.138543543 ----> 3.85 
 
I want to create 'Col2 (computed )' from col1. 
 
Any suggestions? 
 
 
Thanks 
 
<blockquote class='ipsBlockquote' data-author="bhanley">What context are you trying to alter the display. It is a different process (only slightly) for Charts, tables and text objects.</blockquote>

mwilliams

mh10,

Try this for the expression to your computed column:

row["col1_name"].toFixed(2);

That should do it for you. Let me know.

bhanley

You were really close. For the computed column, Javascript is the easiest way to go as formatting with masks is not available there. Try this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>Math.round(row["VALUE"] * 100) / 100</pre>
 
All I did was change the order of operations for how the rounding is handled.

mh10

Thanks Michael.........toFixed(2);.....worked 
 
 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">mh10, 
 
Try this for the expression to your computed column: 
 
row["col1_name"].toFixed(2); 
 
That should do it for you. Let me know.</blockquote>

mh10

Thanks bhanley, 
 
Both ways worked 
 
Math.round(row["VALUE"] * 100) / 100 
row["col1_name"].toFixed(2); 
 
 
Appreciated......... 
 
 
 
<blockquote class='ipsBlockquote' data-author="bhanley">You were really close. For the computed column, Javascript is the easiest way to go as formatting with masks is not available there. Try this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>Math.round(row["VALUE"] * 100) / 100</pre>
 
All I did was change the order of operations for how the rounding is handled.</blockquote>

vishal44

Hi All,
 
I have created BIRT report using php/mysql application.
 
I am using BIRT server, but when single report with huge data my BIRT server goes down and file not found issue occur.
 
BIRT server using 100% CPU.
 
Please reply.
 
Thanks

lixian123

Hi ,I have exponential value example :1.70611548454e power -5 how to show on output using BIRT.Math function ?