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.

`where price is null or price <> 99` – jarlh Sep 17 '20 at 08:38 — jarlh, Sep 17 '20 at 08:38

score 1 · Accepted Answer · answered Sep 17 '20 at 08:43

1

Try this:

ZN([Price])!=99

Wrap this in INT() to sum the result.

answered Sep 17 '20 at 08:43

Andy TAR Sols

1 Answers1