It's based on the displayformat. As an example:
displayname=Running Value of Open PO's
Give that a try.
Hope this helps,
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?
I understand what you're saying, but cannot find that in Legacy Fusion 1.0.
Can you screenshot a bit more, showing me how to navigate there?
Sure, here's step by step... BTW, I'm not in Fusion. I'm in the reporting module in Workfront so maybe that's the disconnect?
1 - Open the Reports page - Select this icon from the Main Menu
2 - Click New Report - Select the type of report - I selected Project for this example
3 - Click Add a Column in the bottom left of the screen
4 - Start typing the field name that you want in the new column - then click on the name
5 - Click the column heading and in the body of the report view you'll see the Summarize this column by drop-down - Select "Sum"
That alone will format the field into currency with comma's when you run the report. Looks like this.
I'm unfamiliar with Fusion so maybe this isn't the correct approach for you. If you want to provide some screenshots that might help me to determine if we're working in the same place.
I couldn't find a function to do this in Legacy Fusion. Crazy as it sounds, you might try writing the number to a Google sheet cell, formatting it, converting it to text, and reading it back.