I am trying to create a simple productivity metric to show how many invoices per AP clerk we process each month. In simplified terms
Invoice Count:= DISTINCTCOUNT([Invoice Number])
FTE Count:= DISTINCTCOUNT([User ID])
Invoice per Clerk:= DIVIDE([Invoice Count], [FTE Count])
But... we have...