inserting a value for empty fields

[Former Member]

The field I'm using for "Group #1" is empty in several records. Is there a way to insert a value (something like "unassigned")  for those fields when I run the report?  Right now they all appear grouped together at the top of the report without a group header.

[abhilash_kumar · Accepted solution]

Hi Tom,

Assuming this is a string field, here's what you need to do :

1) Create a formula with this code:

If (IsNull({string_field}) OR Trim({string_field}) = '') then

'Unassigned'

else

{string_field}

2) Go to the Group Expert > Replace the existing Group with this formula field.

-Abhilash

[Former Member · Accepted solution]

That did it!  Thanks you so much!