5 Replies Latest reply on Feb 4, 2012 10:00 AM by OkcunSahin

    About To Get Mad Because Of A Basic SUM

    OkcunSahin

      Title

      About To Get Mad Because Of A Basic SUM

      Post

      At my database design I have consumers (Consumer_id) and these consumers have invoices (invoice_id) and those invoices have totals (total). I have a different table to sum those invoices due to consumer id and due to month to use it in a script. So I create this relationship as

      Concumer_id = Consumer_id

      Month = Month

      and I created this incredibly basic formula as Sum(consumer::total)

      and it doesn't make the basic sum and I can not understand why. I first tried auto enter and after that I tried calculation and it never changes the result.

      Can anyone understand why???