Planned Hours column formatting

[Laura-MC]

Below is the current text mode for the Planned Hours column in my project report and how it is showing when I run the report. Is there a way I can update the code to have it show 13,798.75 (which adds a comma and removes the word 'Hours')?? The Actual Hours column shows the format I want without changing the code (added this image below as well) but I can't seem to figure out the code to get the Planned Hours to show the format I want. 

aggregator.displayformat=minutesAsHoursString
aggregator.function=SUM
aggregator.namekey=workrequired
aggregator.valuefield=workRequired
aggregator.valueformat=intAsInt
linkedname=direct
namekey=workRequired
querysort=workRequired
valuefield=workRequired
valueformat=compound
viewalias=workrequired

Thanks in advance!!

[Madalyn_Destafney]

Hi there, in your project report > planned hours column, try replacing your text mode completely with this:

displayname=Planned Hours
valueexpression={workRequired}/60
valueformat=doubleAsDouble

Let me know if that's what you're looking for! 

[Laura-MC]

Hi Madalyn - 

Yes, that code worked for the field within the Details tab on the report. However, I'm trying to get that field column settings to 'Summarize this column by:' = 'sum' for the Summary tab on the report. Any suggestions for code to get it to sum all the data?? 🙂

[Madalyn_Destafney]

Hi, not sure I'm following. In the advanced options of that hrs column in details view, do you have it on sum?
I don't think you can modify the language in the Summary tab of the report if that's what you're asking? If you summarize it by Sum in details, it should sum in Summary too.