tableau-apicalculated-columnscalculated-field

How to write a calculated field in Tableau which counts the number of products whose price tags are missing (null) and whose price <> $99?

I tried to write it using ISNULL but I'm getting error.

Solution

  • Try this:

    ZN([Price])!=99

    Wrap this in INT() to sum the result.