6 Replies Latest reply on Apr 25, 2016 11:51 PM by SUNDO KIM

    Give me a correct calculation for total.

    SUNDO KIM
      Column AColumn BColumn C
      USA3.074,9941.25
      CANADA2.167,2591.28
      Total5.2412,253

      5.24

       

       

      I caculate the Column C just like the next.

      SUM([A]) * (SUM([B]) / Total (SUM[B])

      5.24 * (12,253/12,253) = 5.24

       

      But I just want to get 2.53(= 1.25 + 1.28)

       

      What should I do?