Count with if condition

[#1]

I have an expression that is wrong, but should show what I want to do:

COUNT(

  if(((SUM(krankstunden_netto)/SUM(sollstunden_netto))*100)=0,1,0)

)

I want to count the value 1 when the result of the expression is 0

How do I do this correctly in Qlikview?

[#2]

Try something like:

Count({<Stock_Code = {"=if(((SUM(krankstunden_netto)/SUM(sollstunden_netto))*100)=0,1)"}>}Stock_Code)

Replace Stock_Code with your own field

[#3]

Perhaps creating a flag in the back end using the same logic, then counting where field = 0 in the set analysis.

Good Luck,

Pravesh