Tableau — Hard What is the function of the ZN() function in Tableau, and when is it preferred over IFNULL()? A IFNULL() converts nulls to zero; ZN() converts zeros to null B ZN() and IFNULL() are identical in behavior; only the syntax differs C 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 D ZN() is used only for string fields; IFNULL() is used for numeric fields Show explanation
