calculate field with sum
I have got a problem with the sum function. My problem is the following.
I use two tables Account and Bookings
Account with the fields
Bookings with the fieldsaccountnumber_debet
I created a relation between accountnumber and accountnumber_debet. Second i created a relation between accountnumber and
accountnumber_debet (which created a view? with the name Account 2)
the field totamount_debet i calculate with the sum(Bookings::amount) which gave me the correct amounts but now my problem i want t do the same with the field
totamount_credit (sum(Bookings::amount)tbut that gives me wrong amounts
Has anyone an idea how to solve this problem, to calculate the correct amount?