Dear Team.

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

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