Skip to Content
0

Context problem --- total does not match the sum of each

Oct 20, 2016 at 04:12 AM

45

avatar image
Former Member

I am counting number of invoices for 2 sales rep.

These 2 guys work together and form 'Team A'

********************************************************************************

Variable John =Count([Invoice No.]) Where ([Salesman] = "John")

Variable Micahel =Count([Invoice No.]) Where ([Salesman] = "Michael")

********************************************************************************

They both give 10.

John =10

Michael = 10

Problem is that when I count the invoice number for Team A,

it returns 18, instead of 20

*********************************************************************

Variable Team A = Count([Invoice No.]) Where ([Team] = "A")

*********************************************************************

This is because these 2 salesmen work together and share invoice numbers.

How can we get the number of invoice for the team to be 20?

Thanking you in advance....

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Oct 20, 2016 at 01:49 PM
1

try this.

=Count([Invoice No.];all) Where ([Team] = "A")

Share
10 |10000 characters needed characters left characters exceeded