
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 30, 2021 11:27 AM
Hello users!
I have a budget model with a field that automatically calculates state taxes based on the price I include for a given product. In some cases, though, I am not charged any taxes, and my budget doesn’t allow me to leave it as “$0.00” - How can I adjust it so that I can modify the value to $0 when no taxes are charged? See attached
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 30, 2021 11:32 AM
You need a field that indicates whether taxes should be applied or not. Assuming that field is a Checkbox where a check means taxes should be charged, your formula would look like this:
IF({Checkbox}, {TOTAL} * 8.875/100, {Checkbox})
Reply
