Group by value/no value

Question

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 £XXI would like this to be just two groups.Group 1: empty or £0 budgetGroup 2: is more than £0Tried my hand in the text editor but couldn't get anything to work...Thanks in advanced!Screenshot below

Heather_Kulbacki · Accepted Answer

@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

Madalyn_Destafney · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded