Total in table doesn't match individual values

[Anonymous]

I have a straight table in Qlik Sense that calculates the number of Mails answered and the corresponding AHT. Sometimes employees don't use the right status for this work so I disregard these withe the following expression:

if(

24*Sum({<[CICStatus.StatusKey]={'mail'}>}[CICStatus.StateDuration])=0,0,

Sum([NonVoice.verwerkt]))

For individual records this works well, but the table total still calculates all Sum([NonVoice.verwerkt]) since Sum({<[CICStatus.StatusKey]={'mail'}>}[CICStatus.StateDuration]) for the total records is not equal to zero.

Total #Mails should be 64 (18+9+20+17), AHT should be 3600*5,99/64.

Is there a way to have a table calculate a total with above restriction?

[Anonymous]

Fixed by moving the IF statement to the Set expression