Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!
SOLVED

Report Aggregate for Custom Column

Avatar

Level 10

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.

 

NickVa1_0-1713285867815.png

 

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

4 Replies

Avatar

Level 1

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

Avatar

Correct answer by
Level 10

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

Avatar

Level 1

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.

Avatar

Employee

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.