0

formula giving error

Hi,

I am trying to enter the following formula

(6.112*10 ^ (7.5*temp/(237.7+temp))*Humidity/100)

Where temp and Humidity are numeric fields.

 It is giving me an error that symbol expected:”)” at line 1 column 10. The formula is working fine in other database .

7 replies

null
    • Sean
    • 5 yrs ago
    • Reported - view

    Try this...

     

    pow(6.112 * 10, 7.5 * Temp / (237.7 + Temp) * Humidity / 100)

    • subzwari
    • 5 yrs ago
    • Reported - view

    Thank you so much, it works perfectly. just so I understand what does "pow" stand for?

    • Sean
    • 5 yrs ago
    • Reported - view

    Power, so in the formula...

     

    6.112 * 10 - is the power and

    7.5 * Temp / (237.7 + Temp) * Humidity / 100 - is the exponent

    • subzwari
    • 5 yrs ago
    • Reported - view

    thanks, understood

    • Sean
    • 5 yrs ago
    • Reported - view

    You bet. Here's a link to the Ninox functions...

     

    https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

    • Sean
    • 5 yrs ago
    • Reported - view

    Well, at the risk of beating a dead horse I'm going to correct myself 😬. 

     

    6.112 * 10 - is the base and

    7.5 * Temp / (237.7 + Temp) * Humidity / 100 - is the exponent and 

     

    the result is the power

    • subzwari
    • 5 yrs ago
    • Reported - view

    thanks for helping me out, it is very clear now 

Login to reply

Content aside

Categories

View all topics
  • 5 yrs agoLast active
  • 7Replies
  • 1431Views