Transactions with different agents

[ilanbaruch]

hi all

in my model I have two agents for every transaction. agents are coming from different tables in script.

in UI i want to present  count of transactions that both agents are the same i.e:

Agent A	Agent B	RecordKey	CNT
D	A	293581	0
D	A	293591	0
D	A	293601	0
D	B	294711	0
D	B	294721	0
D	B	295161	0
D	B	295241	0
D	B	295431	0
D	C	295441	0
D	C	295731	0
D	C	295841	0
D	D	295851	1
D	D	296121	1
D	D	296351	1
D	D	296731	1
D	D	296771	1
D	D	296951	1
D	D	8208421	1
D	D	8209331	1
A	D	8210241	0
A	D	8211151	0
A	D	8212061	0
A	B	8212971	0
A	B	8213881	0
A	B	8214791	0
A	B	8215701	0
A	B	8216611	0
A	C	8217521	0
A	C	8218431	0
A	C	8219341	0
A	A	8220251	1
A	A	8221161	1
A	A	8222071	1
A	A	8222981	1

any ideas ?

advanced thanks

[GaryGiles]

You could use an if() function inside the count() function, like this:

=count(if([Agent A]=[Agent B],[RecordKey]))