Hi below is my formula for counting the number of transactions. But the issue is I now need to know the NET number of transactions. So if i had 16 sales and 2 returns the total I need is 14 transactions not 18.
TRANS# DISTINCT COUNT:=DISTINCTCOUNT('SALES TABLE'[TRANS#])
Can anyone help with this. Thanks
TRANS# DISTINCT COUNT:=DISTINCTCOUNT('SALES TABLE'[TRANS#])
Can anyone help with this. Thanks