6 Replies Latest reply: Jun 26, 2017 2:57 PM by silvia assuncao RSS

    Sum Total - Maybe with Aggregate

    silvia assuncao

      Hi All!

      I have The total value within the lines are correct, but the total sum is wrong.

      anyone know what change I need in the expression to have the right Total Sum?


      My current expression is: Sum(DISTINCT(if(Month=Month_Working_Days,Working_Days_Qt*8)))