Skip to Content
avatar image
Former Member

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

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....

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 20, 2016 at 01:49 PM

    try this.

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

    Add comment
    10|10000 characters needed characters exceeded