Wrong count in table

[rebma]

Hi 

I have 2 tables.. and from  both tables 

table 1

first name	Last name	dep	Extension Number
john	J.	ABC	455
David	D	ABC	435
Alex	A	DEF	433
Rebbaca	R	DEF	450
William	W	ABC	9014

To	Result
455	missed
435	missed
450	answered
9014	missed
433	answered

and this is table 2

so i try to calculate total missed data from table by creating this formula in blend

Case when Result="missed"  then "1" end

and then calling this formula in table.. but i got wrong count.. 

[sam8]

Your method seems sound. Can you elaborate more about the problem? Did the 1 show up correctly for all the rows it should have? Was the Count correct per row? How off was the count in aggregate?