BAQ Count Unique Values on a record

[tse.dba (Andrew Koemm)]

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!

[zwilli526 (Zack Williams)]

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

[tse.dba (Andrew Koemm)]

Thanks that worked!!