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! 
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
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
