Display Null Values as "Unanswered" or "Unknown" Formula
Updated over a week ago

This article provides the Formula for Null Values to be displayed as "Unanswered" or "Unknown".

Formula to display Null Values as "Unanswered" or "Unknown":
= If IsNull([Data Object]) Then "Unanswered" Else [Data Object]

Example using Gender demographic:

= If IsNull([Gender]) Then "Unanswered" Else [Gender]

Did this answer your question?