Cannot to sum two fields from different tables

[Mantenimiento_S]

Hi you all !!!

I have two tables with numeric fields.

I want to sum in a table the sum of two fields from different tables. For example: Table1, field_1, 

table2, field_2.

Arithmetic expression '([APROVECHABLE]+[DESTGOPEQ])+[DESTPODR])+CALIDAD DE LA FRUTA[TPIEZASCAL])' has inputs of an invalid type 'Unknown'

I don´t know whats the problem with the formula.

Thanks in Advance !!!

[TeeSee1 · Accepted solution]

---

@Mantenimiento_S wrote:

CALIDAD DE LA FRUTA[TPIEZASCAL]

---

This returns a list that contains all the values in that column and is not compatible with the other three. You have to specify which row you want to retrieve the value from by using ANY(SELECT()), LOOKUP(), etc.

[TeeSee1 · Accepted solution]

A select statement requires a constraining condition please read the document.

[TeeSee1 · Accepted solution]

---

@Mantenimiento_S wrote:

CALIDAD DE LA FRUTA[TPIEZASCAL]

---

This returns a list that contains all the values in that column and is not compatible with the other three. You have to specify which row you want to retrieve the value from by using ANY(SELECT()), LOOKUP(), etc.

[Mantenimiento_S]

Hi !!!

Thank you for your answer. I´m trying that, but I get the message: "Select has invalid inputs". This is the formula:

[APROVECHABLE]+[DESTGOPEQ]+[DESTPODR]+ANY(SELECT(CALIDAD DE LA FRUTA[TPIEZASCAL]))

[TeeSee1 · Accepted solution]

A select statement requires a constraining condition please read the document.

[Mantenimiento_S · Accepted solution]

I got it !!!!

Thank you very much for your help.

Javier