0

How to do calculation on sum.

Hi. 

I wondered if it was possible to do anything with the built in sum.  I was wanting to take 1 sum away from another to get a balance.  Or is there a bit of code to sum 2 fields eg credit and debit then subtract one from the other. 

Thanks for any pointers. 

2 replies

null
    • simon
    • 4 yrs ago
    • Reported - view

    By built in sum I assume you mean the one at the end of a table column? You can't use this per se (and note it changes depending on any filters you apply to the table).
    The formula for the sum of values in a a table is simply "sum('Field') - so in your example above, sum(credit)-sum(debit) would give the result you require. Note this this will include ALL credits and debits in a table.

    • simon
    • 4 yrs ago
    • Reported - view

    By built in sum I assume you mean the one at the end of a table column? You can't use this per se (and note it changes depending on any filters you apply to the table).
    The formula for the sum of values in a a table is simply "sum('Field') - so in your example above, sum(credit)-sum(debit) would give the result you require. Note this this will include ALL credits and debits in a table.

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 487Views