Report Aggregate for Custom Column

[NickVa1]

Hi WF Community,

I have an hours report.  I'm referencing a custom field at the program level (DE:WF Total Hours Sold) through a text mode column on the report.  This all works fine.

I want to group the report and have this custom text mode column (DE:WF Total Hours Sold) display the MAX value in the grouping.

I was trying to use the aggregator text mode code, but it doesn't seem to be working:

aggregator.function=MAX
aggregator.namekey=project
aggregator.valuefield=project:program:DE:WF Total Hours Sold
aggregator.valueformat=currencyStringCurrency
displayname=Monthly Contract Value
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=project:program:DE:WF Total Hours Sold
querysort=project:program:DE:WF Total Hours Sold
textmode=true
valuefield=project:program:DE:WF Total Hours Sold
valueformat=currencyStringCurrency

Anyone know where I might be going wrong?

Thanks!
Nick

[JoshuaHa4]

Hello,
I also need to do something similar, by grouping tasks by project and getting a sum total of the custom field output for each project group.

I've been searching, but not yet found a way to achieve this, so thought I'd also throw my hat in the ring!

Thanks,
Josh

[NickVa1 · Accepted solution]

Hi @JoshuaHa4 - 

With the help of Support, I ended up getting this working.  Here's how:

"So in cases like this where we are jumping across multiple data tables, I've found that using valueexpressions tends to work more reliably than valuefields. I updated that and then added a displayformat option to the aggregator. "

Here's the text mode for that column:

aggregator.displayformat=currencyStringCurrency
aggregator.function=MAX
aggregator.namekey=project
aggregator.valueexpression={project}.{program}.{DE:WF Total Hours Sold}
aggregator.valueformat=doubleAsDouble
displayname=Monthly Contract Value
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=project:program:DE:WF Total Hours Sold
querysort=project:program:DE:WF Total Hours Sold
textmode=true
valueexpression={project}.{program}.{DE:WF Total Hours Sold}
valueformat=currencyStringCurrency

[JoshuaHa4]

Hi @NickVa1 ,

That's absolutely fab! Thank you for sharing this with us.

In my case, utilising valueExpression helped, but as did copying the valueexpression directly to the aggregator.valueexpression to make sure this matched perfectly - otherwise it doesn't work!

A couple of weeks can be great for some perspective.

Kind Regards,

Joshua.

[AleciaM1]

If you're still having trouble with this, please consider submitting a ticket to support. We'd be happy to take a look at this with you.