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

    Help with Sum distinct



      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