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.