Credit Debit Balance Issue
In my Db "Purchase list", I have credit debit and balance field. every thing is fine but when debit amount is larger than credit then balance amount is in minus. which is not good. I want to see balance amount as this. if balance amount is credit it should show "Cr5000" and if balance amount is in debit then it should show Db2000, as in picture. How can I do that?