Adjusting the Naming in a Grouping

[MoniqueEvans]

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".

[AnthonyIm]

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!

[MoniqueEvans]

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})

[AnthonyIm · Accepted solution]

You forgot the DE:

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

[MoniqueEvans]

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

OF COURSE!

Thank you so much, I completely forget about the DE