How do I format a number to include commas? For example, I'd like to show 7654321 as $7,654,321 | Community
Skip to main content
J
JohnGr3
Level 2
November 12, 2020
Question

How do I format a number to include commas? For example, I'd like to show 7654321 as $7,654,321

  • November 12, 2020
  • 1 reply
  • 1453 views

How do I format a number to include commas? For example, I'd like to show 7654321 as $7,654,321

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

    1 reply

    T
    TealeMcCleaf
    Level 6
    November 12, 2020

    Hi John,

    It's based on the displayformat. As an example:

    aggregator.displayformat=currencyStringCurrency

    aggregator.function=SUM

    aggregator.valueexpression=SUB({actualAmount}, {plannedAmount})

    aggregator.valueformat=compound

    displayname=Running Value of Open PO's

    linkedname=direct

    textmode=true

    valueformat=customNumberAsString

    Give that a try.

    Hope this helps,

    Teale

      J
      JohnGr3Author
      Level 2
      November 12, 2020

      Thanks Teale!

      Is that Legacy Fusion code? If so, where do I enter that? Is that under-the-covers code?

      T
      TealeMcCleaf
      Level 6
      November 12, 2020

      Hi John,

      This is standard textmode code that you input when you click Switch to Textmode in the report module.

      I typically start by selecting a field that I want to perform the calculation on and add the Sum function to it. Then I click Switch to Textmode and change my valuefield to a valueexpression. In the case of my example, I am subtracting the Actual Amount from the Planned Amount of an expense on the project.

      Does that help?

      Terms & ConditionsAccessibility statement

      Loading footer...