Expand my Community achievements bar.

SOLVED

Adjusting the Naming in a Grouping

Avatar

Community Advisor

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

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

You forgot the DE:

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

View solution in original post

4 Replies

Avatar

Level 10

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!

Avatar

Community Advisor

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

Avatar

Correct answer by
Level 10

You forgot the DE:

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

Avatar

Community Advisor

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

OF COURSE!

Thank you so much, I completely forget about the DE