Skip to Content
avatar image
Former Member

inserting a value for empty fields

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 29, 2016 at 02:09 PM

    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

    Add comment
    10|10000 characters needed characters exceeded