Multiple count

[#1]

Hi,

i have two table call_details & Indent_details both are linked on call_no but for a single call there will be multiple indent_no. so how to find count of call_no having multiple indent_no and single indent_no (this is to find the multiple spare & single spare calls count)

call_details               Indent_details

call no                         indent_no

Can anyone help me plz.

Regards,

Grace

[Gysbert_Wassenaar]

Something like these expressions maybe:

multiple: count({<call_no={'=count(indent_no)>1'}>}distinct call_no)

single: count({<call_no={'=count(indent_no)=1'}>}distinct call_no)