All Collections
ETO Results 4.3
Formulas and Objects
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?