Set Analysis

[rathnam_qv]

Hi all,

i have attached the excel file.....in that i need to find the Count of the field values based on the condition (i.e,A=A1,B=B2,C=C1,D=D1 then count of A,B,C,D) using Set Analysis............

Thanks in advance

smiley

[Gysbert_Wassenaar]

count({<A={'A1'},B={'B2'},C={'C1'},D={'D1'}>}A)

This will return 0 for your sample data since there is no record that fulfills all the conditions.

Unless you mean that only one of the conditions needs to be met, i.e. A=A1 or B=B2 ..etc. In that case use

count({<A={'A1'}>+<B={'B2'}>+<C={'C1'}>+<D={'D1'}>}A)