1 Reply Latest reply: Jun 3, 2012 4:28 PM by Toni Kautto RSS

    Help with Sum distinct

      Hi,

       

      I have the following working exp:

       

      sum({$ <Type -= {'FLEET'}>} if(TD_Commision = [Commission Number],1))

       

      the problem is, there could be repeated data where for example  TD_Commission can occur 20 times, and I am strugling how to add distinct funtion to it.

       

      any ideas 

       

      thanks in advance