Display Null Values as "Unanswered" or "Unknown" Formula

#results

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?