Perhaps already asked in previous discussion, but I couldn't locate.
I am reporting on percentage of patients that met certaincriteria, by facility location.
In some months, for some facilities, there are zero (0) patients(denominator) and my display that represented a percentage of patients that met certain criteria was blank (empty).
In an attempt to display 0.00% (for instances when the denominator was 0), I createdthe following calculations (which do work):
Measure Name: "Count Met Null" (numerator)
Lookup(ZN([Count ofCases Met]),0)
Measure Name: "Count of CSN Null" (denominator)
Lookup (ZN([Count of CSN]),0)
ifnull( [Count MetNull]/[Count of CSN Null],0)
Question: Rather than displaying 0.00%, is there a way to display“NA” or “no patients ”?
I am using version 10.5.
In that case you will need to convert datatype of your column to string. You have to use a calculation something like:
if denominator=0 then 'NA' else numerator/denominator end
Hope it helps.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...