5 Replies Latest reply on Sep 15, 2017 7:03 AM by Deepak Rai

    Distinct Count Question

    Colin Clark

      See example below. I am trying to get the number of stocks traded by exchange. If the volume is 0, then it is not counted. I tried a calculated field of COUNTD[Symbol], but that still shows up 3 stocks traded for Exchange 1, but I only want 2 stocks traded. Thoughts? Thanks in advance.

       

      Volume by Symbol by Exchange
      SymbolExchange 1Exchange 2
      FB02
      GOOG108
      AAPL157
      # of Stocks Traded23