Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula condition

711 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jahsun_Daher_Go
4 - Data Explorer
4 - Data Explorer

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 Screen Shot 2021-09-30 at 2.25.57 PM

1 Reply 1

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})