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 !!!
Solved! Go to 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.
A select statement requires a constraining condition please read the document.
@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.
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]))
A select statement requires a constraining condition please read the document.
I got it !!!!
Thank you very much for your help.
Javier
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |