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
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

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

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?

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?