Loading request...
Request for a feature to display blank values as 'n/a' in matrix visuals without affecting the numerical integrity of the data.
I am calculating the % variance from last year in a matrix. My measure is using IF last year sales $0, leave BLANK(). I would like to replace the blank values with “n/a” but don’t want to hardcode text in the measure as it would mess with visuals. Is there any way to display blanks as n/a without damaging the numerical value of blank?