My formula doesn't work
Hello! I am admittedly new to quickbase. I am having problems with my formula in a table not working.
(10^(6.67956-(1002.711/(((Average([Return bend Temp 1],[Return bend Temp 2],[Return bend T...
Forum Discussion
Hard to say since there is a lot going on, but I would troubleshoot by breaking it down in small increments.
Only do the Average and check the result. Once correct, add the number. Check result. Then multiply. Check result. You'll narrow it down.
------------------------------
Mike Tamoush
------------------------------
Only do the Average and check the result. Once correct, add the number. Check result. Then multiply. Check result. You'll narrow it down.
------------------------------
Mike Tamoush
------------------------------
- Also, when you say 'not working', what do you mean? It gives you the wrong number? It gives you an error and you can't even save?
------------------------------
Mike Tamoush
------------------------------- When I say "not working" I mean the result I get is
-[System Discharge Pressure]
The rest of the calculation doesn't happen.
------------------------------
Nick Van Laar
------------------------------- What is the field type? Can you share a screenshot or paste the code from the formula field?
------------------------------
Jeff Peterson
------------------------------
- After checking as you suggested, It falls apart when I add 10^(rest of formula).
It seems as though quickbase can't handle negative exponents. If I set it up as 10^-(rest of formula) to turn the negative into a positive, the calculation works (just not the right answer since it should be negative).
------------------------------
Nick Van Laar
------------------------------- If I remember my math correctly, isn't a negative exponent the same as 1 divided by the number?
So 10^-1 = 1/10^1?
If that is correct and the exponent will always be negative, just put a 1 on the numerator of the whole thing.
If the number wont always be negative, simply make a variable for the first part to get the number. Then say, if negative, 1/10^postivevariable, else 10^variable
------------------------------
Mike Tamoush
------------------------------
