7 Replies Latest reply: Feb 15, 2017 3:00 AM by Kevin Somosera

# Expression to round up the Pie Chart Share

Hi,

I just want to ask how can I customize my Pie chart share so that I can make the share round up and doesn't contain decimal values. here is my Pie chart for reference.

For now my current settings is Share because it is the one that shows values in percentage. For example.the 32.1% will be 32% but will rise up to 33% when it gets to 32.5%. I hope you can help me with this. Thanks!

• ###### Re: Expression to round up the Pie Chart Share

Hello, did you try use the function Round()?

• ###### Re: Expression to round up the Pie Chart Share

=NUM(Expression,'#,###.%')

Regards

Pratyush

• ###### Re: Expression to round up the Pie Chart Share

use Round(YourExpression)

• ###### Re: Expression to round up the Pie Chart Share

Hello Kevin,

Trust that you are doing great!

To fix this, open chart properties and go to the Number tab. Select the expression you want to format; Select Integer & tick Show in Percent (%) check box and click OK.

Hope this will be of help.

P.S.: I have used expression as Count([Project id])/ Count(TOTAL [Project id])

Regards!

Rahul

• ###### Re: Expression to round up the Pie Chart Share

Thanks! It solved my problem!

• ###### Re: Expression to round up the Pie Chart Share

Hi Kevin,

If Fixed To number formatting is selected then remove the decimal number from it.

Use below Expression

=Count(Field)/100   or  Count(Field) / Count (Distinct Field)

In Number Property

Select  Fixed To Number Format Setting Radio Button. Don't add any value in  Decimals.

Check the Show in Percent (%) checkbox.

Please find the attached app for the example.

• ###### Re: Expression to round up the Pie Chart Share

Hi Kevin,

If Fixed To number formatting is selected then remove the decimal number from it.

Use below Expression

=Count(Field)/100   or  Count(Field) / Count (Total Field)

In Number Property

Select  Fixed To Number Format Setting Radio Button. Don't add any value in  Decimals.

Check the Show in Percent (%) checkbox.