Hello,
I have a currency formula field that is subtracting a number of costs from a commission owed to a sales rep. The number tends to come up negative from time to time.
I would like 1 of 2 options to support our math:
1) Set up the currency formula field so it cannot be a number below 0.
2) Create an additional field that will reflect the number shown in the currency formula field if it's above 0, and if it's less than 0 or a negative number, it will keep itself at 0
In regards to option 2, I've attempted to use rules for that to occur but once the 'Project Cost' is created with the related information from another table, it will not 'fire a change' if it changes after it's been created.
Thank You so much for your support.
------------------------------
Anthony Wong
------------------------------
Question
How to keep a formula from going below 0 (Keep it as 0 or higher)
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.