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
------------------------------
------------------------------
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
------------------------------- Field type is numeric.
Excel formula (works):=(((POWER(10, (6.67956-(1002.711/(((A2+459.67)*(5/9))-25.215)))))*0.145)-14.7)-D1quickbase equivalent (does not work):(10^(6.67956-(1002.711/(((Average([Return bend Temp 1],[Return bend Temp 2],[Return bend Temp 3],[Return bend Temp 4])+459.67)*0.145)-14.7))))-[System Discharge Pressure]
------------------------------
Nick Van Laar
------------------------------
- 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
------------------------------- Nope. It still doesn't like that.
It will calculate:
10^-(rest of formula) [wrong answer]
but not
1/10^-(rest of formula) [theoretically correct]
or
10^(rest of formula) [correct]
Is this a bug?
------------------------------
Nick Van Laar
------------------------------
