12 Replies Latest reply: Feb 14, 2012 8:42 AM by David Simpson RSS

    Total formula not giving the result I want

    David Simpson

      I am having trouble with totals. I have managed to get the correct total in a stragit table by using the Sum of Rows. However I want to repeat this total in a text box but I can only get the total that the straight table displays when expression total is selected.

       

      I guess the sum of rows is doing something that I am missing from my formula in my text box.

       

      =if(sum([Local Line Total Amount]=0),sum([Local Budget Amount]),sum([Local Item Extended Price]))  this keeps giving me 6785530 but I know it should be 3210890

       

      This is the table with totals at the top. Clearly the first column is totalled incorrectly and the second is correct but my formula gives me the first total.

       

      67855303210890
      101500015000
      18210000210000
      3220000002000000
      51100000100000
      52155100155100
      654400044000
      72200000200000
      764171841718
      782781227812
      8625602560
      894500045000
      906100061000
      918400028000
      923000030000
      944000020000
      1066750067500
      107208000100000
      1081200012000
      11823001200
      1195000050000

      Any ideas? Please.

      Thanks in advance.