Math Operation

Ask for Help
1

Dear Team.

I want to calculate Available Balance from below table, please guide.

image
image887×147 3.75 KB

2

I would probably structure it differently, but given the way you have presented it, you could do the following:

  • Create an if-then-else column (ifDebit):
    – If DebitCredit is DR, then Amount
    – If DebitCredit is Dr, then Amount
  • Create another if-then-else column (ifCredit)
    – If DebitCredit is CR, then Amount
  • Create a Rollup column that takes a sum of the ifDebit column. This will be the Total Debit
  • Create a Rollup column that takes a sum of the ifCredit column. This will be the Total Credit.
  • Create a Math column to calculate the Available Balance. The formula should be: Total Credit - Total Debit
1 Like