Jump to content
Sign in to follow this  
Zaid

Boolean Calculation Help

Recommended Posts

Hi Everyone! I Have no idea how to perfom this script.

I have a Radio field for customers who are 'Reseller', with radio buttons "Yes" and "No". I want another field called: 'Sales Tax Rate'

to calculate itself to add a sales tax value of .0825 for non-resellers and 0 for resellers

Basically i want the field 'Sales Tax Rate' to:

if [ ( Reseller) = "Yes" ]

return a 0 to field 'Sales Tax'

else

return 0.0825 to field 'Sales Tax'

Sorry if my coding is cheap im just a beginner.

Share this post


Link to post
Share on other sites

The "smarts" should be in the Sales Tax field, not the Sales Tax Rate field.

Sales Tax =

if (Reseller = "Yes" , 0, Sales Tax Rate * SubTotal)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.