I have a query that has the follwing fields:
Gross Payment :Currancy
Tax Discount: Boolean (Yes/No)
I want to create a new field called Tax Deducted that if the tax discount is no, the Tax deducted = Gross Payment * (22/100) but if tax discount is yes, then Tax Deducted = 0.
I'm not sure if...