2 Replies Latest reply on Mar 31, 2016 1:40 PM by John Thompson

    Need help with a count calulation

    John Thompson

      I need help with writing a calculation to give me a count that gives me a distinct number rather than a sum or average over several days.

       

      Example:

       

      I have 3 companies; Company A has 575 games, Company B has 80 games and Company C has 70 games.

      These counts rarely change day by day.

      When I run a date range for simple sales for example from 3/1st thru 3/5th the grand totals show the sum of all vendors rather than each company set game count.

      Any help with this question will be greatly appreciated.

      Thanks in advance.