Divide two different quantities in differents tables

[VillitaDevelop]

Hello,
I have two tables PALLET_INFORMATION and REPORT, within PALLET_INFORMATION I have a field that is Scar% where I want the result of dividing a value within REPORT called SCARS-RUSSETING of type number between the Size value that is in the REPORT table. but the expression I use gives me an error.

(PALLET_INFORMATION[SCARS-RUSSETING] / REPORT[SIZE/ CALIBRE])

Message

The expression is valid but its result type 'List' is not one of the expected types: Percent

[lynchk21 · Accepted solution]

Your expression is pulling two lists, rather than two values.

table_name[{column_name]} is of type list, not a unique value. 

You can use SUM(), AVERAGE(), MIN(), MAX(), ANY(), MAXROW(), MINROW() or other expressions to get a single value for each list, rather than the whole list. It will depend on what exactly you are trying to calculate.

[VillitaDevelop]

HI 

thanks for the support, It was very useful to me, I was now able to solve my problem.