Adjusting the Naming in a Grouping | Community
Skip to main content
MoniqueEvans
MoniqueEvans
New Participant
Nov 5, 2020 5:06 PM UTC
Solved

Adjusting the Naming in a Grouping

I'm blanking on if this is possible. is it possible to alter the text in a Grouping on a report. I have a project report that is grouped by Program and I would like the Grouping to show "Program name - Program Custom Field" the name of the field is called "SKU Count".

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    imgrund
    imgrundAccepted solution
    Employee
    Nov 5, 2020 5:36 PM UTC

    You forgot the DE:

    group.1.valueexpression=CONCAT({program}.{name}," - ",{program}.{DE:SKU Count})

    View reply

    4 replies

    MoniqueEvans
    MoniqueEvansAuthor
    New Participant
    Nov 5, 2020 5:32 PM UTC

    I tried doing a valueexpression and CONCAT but I think I screwed something up. Can you reply with a sample expression I can tweak? I keep getting NULL_OBJECT

    group.1.valueexpression=CONCAT({program}.{name}," - ",{program}.{SKU Count})

    Translate
    imgrund
    imgrundAccepted solution
    Employee
    Nov 5, 2020 5:36 PM UTC

    You forgot the DE:

    group.1.valueexpression=CONCAT({program}.{name}," - ",{program}.{DE:SKU Count})

    Translate
      MoniqueEvans
      MoniqueEvansAuthor
      New Participant
      Nov 5, 2020 5:39 PM UTC

      🤦🏾‚Äç‚ôÄÔ∏è🤦🏾‚Äç‚ôÄÔ∏è🤦🏾‚Äç‚ôÄÔ∏è

      OF COURSE!

      Thank you so much, I completely forget about the DE

      Translate
      imgrund
      imgrund
      Employee
      Nov 5, 2020 5:26 PM UTC

      You can use valueexpression and CONCAT on a grouping as long as you don't want it to be a chart or use the Summary tab.

      I have a task report that has like, no joke, 6 different Project fields on the grouping so the team can see info they need to. LOL!

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...