COUNT field Completed Calls

Question

Hi all 
 I have looked around Sugar guides and club but cannot find the solution to a current scenario 
 
 We have a calculated integer field for COUNT Calls

This counts all calls related to the Lead 
 
 Is there a way to have COUNT calls where status = Completed 
 
 I was hoping something like this would work 
 count(related($calls,"status"),"Completed") 
 but get the following error

Any support would be greatly appreciated!

Taufique Ahmed · Accepted Answer

Hi Taufique Ahmed , 
 The formula to use to achieve this outcome is countConditional. Based on your example, the following formula should work: 
 countConditional(
 $calls,
 "status",
 createList(
 "Completed"
 )
) 
 Chris