POWER

[Eera_Pendharkar]

I am trying to use the POWER() expression to calculate values for the column 'Vel_1', but it is giving an error message- 'Arithmetic expression '("Pipe ID"/12)' has inputs of an invalid type 'Unknown''. 

The expression is is giving results for values from the same table, but is giving the error message when values from different tables are used, eg.- "Pipe ID".

Can anyone help me with this?

[Suvrutt_Gurjar]

The syntax of the expression is incorrect.

---

@Eera_Pendharkar wrote:

'Arithmetic expression '("Pipe ID"/12)'

---

If the column is from the same table, the expression syntax will be something like POWER( [Pipe ID]/12, 2)  or POWER( [Pipe ID]/12.00, 2) if you are expecting the division to return a value with decimals and fractions. The column name needs to be enclosed in square brackets. Please take a look at the below article on using constants and column values in expressions.

Expressions: The Essentials - AppSheet Help

---

@Eera_Pendharkar wrote:

The expression is is giving results for values from the same table, but is giving the error message when values from different tables are used, eg.- "Pipe ID".

---

If the [Pipe ID] is a column in different table, you will need to specify row from where you wish to fetch the said value. You may need to use an expression something like LOOKUP() or referencing between tables.

LOOKUP() - AppSheet Help

References between tables - AppSheet Help