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.

[Kurt_Jones]

Laura,

if you try aggregator.valueformat=doubleAsInt does that get you what you want?

[Laura-MC]

Hi Kurt - that doesn't seem to work. What Madalyn said above about not being able to modify the language of the summary tab is most likely the culprit. I've tried a whole bunch of code and can't seem to find a way to just add a comma and remove the word 'hours' on the aggregator language but it isn't the end of the world - just doesn't look at pretty 🙂 

Thank you!

[kautuk_sahni]

@Laura-MC Just checking in! Were you able to get this resolved? If you found your own solution, sharing the details would be a big help to others who might face the same issue later on. And if one of the replies here helped, whether it fully solved the problem or simply pointed you in the right direction, marking it as accepted makes it much easier for future readers to find. Thanks again for helping close the loop and contributing to the community!