14 Replies Latest reply: Jul 18, 2014 10:32 AM by Marius Koekemoer RSS

    Total does not add up

      Good day

       

      I have a chart where every column's total adds up correctly except for the last column which should show the total as R384.88 but it shows R389.98. I don't know why. Can someone help please.

       

       

      KEYWORDNOAMOUNTAMT PER NONO OF LEADSCOST PER LEAD
      TOTAL163R1,767,380.59R10,842.834,592R389.98
      Sun45R627,008.68R13,933.531,852R338.56
      Move14R297,787.00R21,270.50554R537.52
      Kaap35R213,786.72R6,108.19642R333.00
      Family6R205,650.00R34,275.00379R542.61
      krag6R111,055.50R18,509.25198R560.89
      Goal6R90,732.60R15,122.10255R355.81
      Iso18R80,598.01R4,477.67180R447.77
      Ilanga17R69,186.35R4,069.79165R419.31
      Value3R38,181.15R12,727.05102R374.33
      Sonto12R24,771.86R2,064.3246R538.52
      Nurse1R8,622.72R8,622.7211R783.88
      Bona0R0.00-54R0.00
      Drum0R0.00-38R0.00
      Rights0R0.00-38R0.00
      You0R0.00-38R0.00
      New0R0.00-14R0.00
      World0R0.00-2R0.00
      Love0R0.00-2R0.00
      Mthatha0R0.00-2R0.00
      Khosi0R0.00-11R0.00
      Kick0R0.00-1R0.00
      City0R0.00-1R0.00
      Times0R0.00-1R0.00
      Day0R0.00-6R0.00