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
Solved! Go to Solution.
Views
Replies
Total Likes
@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
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.
Views
Replies
Total Likes
@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
Views
Likes
Replies