Adjusting the Naming in a Grouping

Forum|Forum|5 years ago
November 5, 2020
4 replies
995 views

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.

Best answer by imgrund

You forgot the DE:

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

imgrund

Adobe Employee

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

Author

Adobe Champion, Community Advisor, UG Leader

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

imgrund

Accepted solution

Adobe Employee

You forgot the DE:

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

MoniqueEvans

Author

Adobe Champion, Community Advisor, UG Leader

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

OF COURSE!

Thank you so much, I completely forget about the DE

Sign up

Login with SSO

Login to the community

Login with SSO