0

Need help with converting FileMaker formula to Ninox

13.12+(.6215*g_Main_temp)-(11.37*g_Main_Wind ^ .16)+(.3965*g_Main_temp*g_Main_Wind ^ .16)

3 replies

null
    • subzwari
    • 4 yrs ago
    • Reported - view

    I have tried:

    pow(3.12 + 0.6215 * Temperature - 11.37 * Wind, 0.16) + pow(0.3965 * Temperature * Wind, 0.16)

    But the result is not as expected. Please advise if pow is in the correct location.

    • Birger_H
    • 4 yrs ago
    • Reported - view

    You can book a complementary screensharing session with me via this link:
    https://calendly.com/birger-hansen/15min

    Birger

    • Anon_Anon
    • 4 yrs ago
    • Reported - view

    Based on the FileMaker formula, the correct Ninox formula would be the following:

    13.12 + (0.6215 * Temperature) - (11.37 * pow(Wind, 0.16)) + (0.3965 * Temperature * pow(Wind, 0.16))

    The FileMaker formula was only taking the g_Main_Wind to the power of 0.16. This is a mathematical convention. The order of operations dictates that an exponential operation (like power) happen before multiplication.

    Hope this helps!

     

     

Content aside

  • 4 yrs agoLast active
  • 3Replies
  • 1202Views