1 Reply Latest reply: Feb 23, 2018 6:33 AM by Callan Dooley RSS

    Sum fucntion not counting values which are the same

    Callan Dooley

      Hello,

       

      I was wondering if you guys could help.

      Below is a table with groupings. The value highlighted in yellow is the totals field of all the values in red.

      The only issue is the totals doesn't count all three of the same values (In Blue) it only counts one.

       

      Here is my function. - sum(distinct{<[DG.class]={1}>+<jobnum={jobnum}>}[DG.uomactqty])


      I believe its to do with the 'Distinct' but i need this as otherwise my figures (In red) are not correct.

       

      Any Ideas?

      Capture.PNG