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)))