Tableau — Hard What is the function of the ZN() function in Tableau, and when is it preferred over IFNULL()? A ZN() converts null values to zero and is preferred when null means 'no data and should be treated as zero' for numeric calculations; IFNULL() replaces null with any specified value and is more general-purpose for non-numeric or non-zero replacements B IFNULL() converts nulls to zero; ZN() converts zeros to null C ZN() is used only for string fields; IFNULL() is used for numeric fields D ZN() and IFNULL() are identical in behavior; only the syntax differs Show explanation
