AnsweredAssumed Answered

Tax Rate Checkbox

Question asked by Ryusui on Jan 13, 2016
Latest reply on Jan 13, 2016 by macwombat



I would like to have a checkbox which I can use to have my database choose from either a retail or wholesale tax rate.  Basically, I want the tax rate to default to retail if the box is unchecked, and to change to wholesale if the box is checked.  I tried setting up a checkbox field and using a CASE statement in my tax rate field, but it's not working.  Here's what I have as a calculated value:

Case ( Weddings::tax_wholesale = "Wholesale" ; "0.005" ; "0.0417" )

However, all this does is use the wholesale tax rate if checked, and use nothing if unchecked.  Also, the tax field doesn't update in real time.  If I check or uncheck the field, and then move to a different record and back again, it will then have updated.  I want to be able to have the checkbox update the field while I'm live in the record.


Thanks for your help!