Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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