AnsweredAssumed Answered

About To Get Mad Because Of A Basic SUM

Question asked by OkcunSahin on Jan 31, 2012
Latest reply on Feb 4, 2012 by OkcunSahin


About To Get Mad Because Of A Basic SUM


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