Return related records based on conditional checks

Hello,

We have recently implemented Sugar Sell on Cloud. I have an ''Opportunity Module" which is related "Meeting" module in a 1-to-M relationship. I am trying to create a Calculated field on "Opportunity" module that will count meetings conducted based on "Meeting Type" which is a drop down field in "Meeting" module.

I am using the following formula:  countConditional($meetings,"type",createList("Client","Triparty")) which is working.

BUT we only want to COUNT "Meeting Type" based on above formula when another drop down field "Meeting Status" is of type "Held". How do we accomplish the additional check along with countConditional function?

Regards - AP

Parents Reply Children
No Data