AnsweredAssumed Answered

calculate field with sum

Question asked by goosse on Jan 5, 2009
Latest reply on Jan 6, 2009 by goosse

Title

calculate field with sum

Post

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

accountnumber
accountname
totamount debet
amount credit

 

Bookings with the fields

accountnumber_debet
accountnumer_credit
amount
date

 

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?



Outcomes