Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Group by value/no value

Avatar

Level 1

Hey all,
Apologies if this has already been covered but I can't find anything. 
I have a report, that's grouped by the client's budget (brought in from request field), this is either empty, £0 or £XX
I would like this to be just two groups.
Group 1: empty or £0 budget
Group 2: is more than £0

Tried my hand in the text editor but couldn't get anything to work...

Thanks in advanced!
Screenshot below
Screenshot 2024-04-30 at 16.40.27.png

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@michelleb526471  give this text mode grouping a try:

 

group.0.linkedname=direct
group.0.namekey=DE:Your Custom Field Name
group.0.valueexpression=IF({DE:Your Custom Field Name}>0,'more than £0','empty or £0','')
group.0.valueformat=doubleAsString
textmode=true

View solution in original post

2 Replies

Avatar

Community Advisor

Hello, the way I'd go about this is to add a calculated custom field in the same custom form where the client budget field lives, say it's called 'Client Budget Calculated Field.' Have this field reference the client budget field with a calculation if budget greater or equal to X, show as Y. If less than A, show as B. 

Then your grouping in the report would be grouping by this new 'Client Budget Calculated Field' Is Not Blank to pull in where this field has a value. 

If this helped you, please mark correct to help others : )

Avatar

Correct answer by
Community Advisor

@michelleb526471  give this text mode grouping a try:

 

group.0.linkedname=direct
group.0.namekey=DE:Your Custom Field Name
group.0.valueexpression=IF({DE:Your Custom Field Name}>0,'more than £0','empty or £0','')
group.0.valueformat=doubleAsString
textmode=true