Calculate fields in database or report
First of all my native language is not english so sorry for that.
Second my problem is this i have a table with a few columns like accountnumber and amount_debet and amount_credit
I would like to calulate all the acountnumbers with the same number the amount_debet and the amount_credit.
I allso have to do some other calculations with these amounts. My question is do i have to do those calculations in the database and do i have to create some extra fields in my tables or can i do these calculations on the report i generate?