I’m trying to create a formula field that’ll output a sales tax amount based on another field in the base.
So:
IF {Tax Type} = HST, multiply {Subtotal} by 13%,
IF {Tax Type} = GST, multiply {Subtotal} by 5%,
IF {Tax Type} = “Zero-rated”, type “0%”, e...