Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question