Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)