How do I suppress the cents in a chart? | Community
Skip to main content
C
Christina_DeBonis
Level 2
July 13, 2020
Question

How do I suppress the cents in a chart?

  • July 13, 2020
  • 1 reply
  • 498 views

I have a report comparing Planned Cost and Actual Cost with the column field format set to $1,234. However, the chart for this report that I want to place on a dashboard is including the cents value ($1,234.56). How do I not have the cents appear in the chart? I hope this is an easy one for someone to answer as I could not find anything in help articles.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    Heather_Kulbacki
    Community Advisor
    Heather_KulbackiCommunity Advisor
    Community Advisor
    July 14, 2020

    Hi Christina,

    In the Edit area of your report, select the column and click on Advanced Options - there's a field format there where you can choose whether the cents are included or not.

    C
    Christina_DeBonisAuthor
    Level 2
    July 14, 2020

    Heather,

    Thanks for your response. I do have the field format set at $1,234, but the chart is showing $1,234.56. This is the issue I am having. I'd like the chart to not show the cents and I'm not sure how to make that happen. I was hoping there was a simple solution.

    Christine

    Terms & ConditionsAccessibility statement

    Loading footer...