Solved: Divide two different quantities in differents tabl... - Page 2

VillitaDevelop · 03-22-2024 06:37 AM

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

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.

View solution in original post

Divide two different quantities in differents tables