5 Replies Latest reply on Nov 6, 2018 7:06 AM by Jim Dehner

    Distinct count of suppliers in time period

    Jeo Thomas

      Hi All,

       

      I am trying to calculate a distinct supplier count in a time period, for that, I used below calculation

       

      INT({ FIXED [Posting Date] : COUNTD([Supplier Name])})

       

      But it is not giving the true distinct count, maybe it is because the same supplier is repeated in different dates.

       

      Would someone be able to help me to solve this problem?

       

      Thanks!