All Collections
Help Articles
Reporting in ETO
Functions and Formulas
ETO Results | Formulas: Display Value for Null Values
ETO Results | Formulas: Display Value for Null Values

BO 4.3 Platform

Updated over a week ago

This article provides the Formula for Null Values to be displayed as "Unanswered" or "Unknown" rather than appearing empty in a report table.
​
​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?