I have two tables: BEN and EMP. Inside EMP there is a column called empCode, which is also present in BEN. I would like to create a column in EMP, that will count how many times the empCode matches rows inside BEN empCode column.
On Excel, I would run this formula
Let’s say EMP has two rows and their empCode values are ABC, DEF. Inside BEN there are 8 rows: ABC, DEF, DEF, ABC, DEF, ABC, ABC, DEF. Thereby my column in EMP, lets name it Total, would then need to show 4 in the row that has ABC, and 4 in the row that has DEF.