Division expression

[Cyrine_Mae_Mend]

Hi,

Please help. I want to get the quotient of 2 columns where the dividend comes from the parent table and the divisor is from the child table.

I tried to write this expression (Data WSJF[WSJF Computation] / [Computation P3])

but I got an error :
Arithmetic expression ‘(Data WSJF[WSJF Computation]/[Computation P3])’ has inputs of an invalid type ‘Unknown’

Items :
Data WSJF - Parent Table
WSJF Computation - Column from the parent table (dividend)
Computation P3 - Column from the child table (divisor)

Please suggest how to translate it to AppSheet expression.

[Steve · Accepted solution]

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

help.appsheet.com

List from Table-Column Reference

Create a list from the values in a column of a table.

[Cyrine_Mae_Mend]

Thank you, Steve! It works!