Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could use an if() function inside the count() function, like this:
=count(if([Agent A]=[Agent B],[RecordKey]))