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

Question

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

Answer 1

Try this:

ZN([Price])!=99

Wrap this in INT() to sum the result.