My formula doesn't work

Question

Hello!&nbsp; I am admittedly new to quickbase.&nbsp; 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 Temp 3],[Return  bend  Temp 4])+459.67)*0.145)-14.7))))-[System Discharge Pressure]​
"Return Bend 1, Return Bend 2, Return Bend 3, Return Bend 4 and System Discharge Pressure" are all user inputs.&nbsp; For instance, if I enter:RB1 = 80.8RB2 = 80.4RB3 = 80RB4 = 80.6System Discharge = 140This should yield: 1.161Am I inputting the formula wrong or missing something? Using the wrong nomenclature?I worked this formula out in Excel first and verified it works then transferred it to quickbase:=(((POWER(10, (6.67956-(1002.711/(((A2+459.67)*(5/9))-25.215)))))*0.145)-14.7)-D1Any help is appreciated!&nbsp; Thank you!------------------------------Nick Van Laar------------------------------

miketamoush · Answer

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
------------------------------

miketamoush · Answer

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
------------------------------

nickvan_laar · Answer

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------------------------------

jeffpeterson1 · Answer

What is the field type?&nbsp; Can you share a screenshot or paste the code from the formula field?------------------------------Jeff Peterson------------------------------

nickvan_laar · Answer

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.&nbsp; 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------------------------------

Forum Discussion

My formula doesn't work

10 Replies