Formula Numeric Field
Looking for some help with a formula for a Formula Numeric field. So we give full-time employees 14 paid days off per year. So if they work the full year it is easy to calculate how many days off ...
Forum Discussion
Thank you Don!
------------------------------
Mark Comish
------------------------------
------------------------------
Mark Comish
------------------------------
Hello Don,
Can you please help me, I am trying to do a simple formula by adding # to another # and then dividing it into another (example: Total Complete + Total Exempt / Total Training Assignments) Is there something I am doing wrong in the system because the # comes out very large and it shouldn't?
1303282+67040/1942651=.70% but the system says 130,328,203.5%
Here is how I have it in the system:
Thanks,
Alan
------------------------------
Alan Orbach
------------------------------
Can you please help me, I am trying to do a simple formula by adding # to another # and then dividing it into another (example: Total Complete + Total Exempt / Total Training Assignments) Is there something I am doing wrong in the system because the # comes out very large and it shouldn't?
1303282+67040/1942651=.70% but the system says 130,328,203.5%
Here is how I have it in the system:
Thanks,
Alan
------------------------------
Alan Orbach
------------------------------
- MarkShnier__You
Qrew Legend
Alan,
In mathematics, Excel and Quick Base, Multiplication and Division take precedence over Addition and Subtraction in the of the order of operations.
If you want the Addition to take precedence, you will need brackets
([Field 1] + [Field B]) / [Field C]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - Alan,
Mark is correct.
There is mnemonic for remembering how math formulas work called PEMDAS.
Parentheses
Exponents
Multiply or Divide
Add or Subtract
If you build your formulas with this in mind, evaluating left to right. Quick Base, Excel and other systems will give you the same answer.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
