BAQ Count Unique Values on a record

See my query below:

I want to add a column that will count the amount of zeros that appear in a single row.
Anything the a research tells me how to count values in a column

Any ideas?

Thanks!

Adding each column using a case statements would work.

CASE WHEN LastMonthTotal = 0 THEN 1 ELSE 0 END +
CASE WHEN ThisMonthTotal = 0 THEN 1 ELSE 0 END +
ā€¦ case statement for all other columns being checked

1 Like

Thanks that worked!!