Planned Hours column formatting | Community
Skip to main content
Laura-MC
Laura-MC
New Participant
September 15, 2025
Question

Planned Hours column formatting

  • September 15, 2025
  • 2 replies
  • 494 views

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

 

2 replies

Kurt_Jones
Kurt_Jones
New Participant
September 19, 2025

Laura,

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

Laura-MC
Laura-MCAuthor
New Participant
September 19, 2025

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!

Madalyn_Destafney
Madalyn_Destafney
New Participant
September 15, 2025

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! 

If this helped you, please mark correct to help others : )
Laura-MC
Laura-MCAuthor
New Participant
September 16, 2025

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
Madalyn_Destafney
New Participant
September 18, 2025

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.

If this helped you, please mark correct to help others : )
Terms & ConditionsAccessibility statement

Loading footer...