3 Replies Latest reply on Jul 11, 2013 11:46 AM by Jonathan Drummey

    Total/Subtotal not summing correctly

    Annamarie McGowan

      I am trying to count distinct based on a calculated field,  here is the code I am using:

      if sum([Cloud]) > 0 then COUNTD([Sales Rep]) else 0 end

       

      It is calculating all rows,  not just the rows with the value greater than zero??