How to count valuse from possiable value list??

[david_ze]

hi,

I have two tables: A and B:

A			B
A	B		A	C
1	1		55	1
2	1		43	1
3	1		2	1
4	1		7	1
5	1		9	1
6	1		11	1
7	1		17	1
8	1		88	1
9	1		1	1
10	1		6	1

I would like to count column C each time the A value exists in both table.

In the above example the result should be 5.

How should I do this?

Will appreciate your help.

Thanks in advanced,

David

[#2]

Hello David,

since I do not know where you want to use it, my suggestions:

a) in a straight table as a calculated dim like =if(B=C, A) and an expression like count(C)

b) in a text-box like =count(if(B=C, C))

If you need it more often, I would think about doing the count during loading and store it in a new field ("D")

HtH

Roland