Solved: Look Up Expression No Return Value - Page 2

reggieneo · 03-20-2021 09:45 PM

Hi All,
Why I can’t get any result in this expression:
LOOKUP([_THISROW].[Materials],“HW Products”,“Product Name”, “Price”)

Return Zero

My Product Table:

thanks

Suvrutt_Gurjar

Maybe you wish to try, assuming [Materials] is a reference column that references ,“HW Products” table,

LOOKUP([_THISROW].[Materials],“HW Products”,“Product Key”, “Price”)

Or if the table “HW Products” is referenced in the table where the form picture you have shared is based of, you may wish to also try

[Materials].[Price]