Report Aggregate for Custom Column | Community
Skip to main content
N
NickVa7
Level 9
April 16, 2024
Solved

Report Aggregate for Custom Column

  • April 16, 2024
  • 2 replies
  • 985 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by NickVa7

    Hi @joshuaha14 - 

    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

    2 replies

    J
    JoshuaHa14
    Level 2
    April 19, 2024

    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

    N
    NickVa7AuthorAccepted solution
    Level 9
    May 1, 2024

    Hi @joshuaha14 - 

    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

      J
      JoshuaHa14
      Level 2
      May 2, 2024

      Hi @nickva7 ,

      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
        Adobe Employee
        AleciaM1Adobe Employee
        Adobe Employee
        April 30, 2024

        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. 

          Terms & ConditionsAccessibility statement

          Loading footer...