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
Solved! Go to Solution.
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]
Try to remove [_THISROW] and see if you can get the result. Did you place the expression in the initial value of the Unit-Cost column?
I tried it without the [_thisrow]. doesnโt work.
it is in initial value of Unit Cost.
I even used Any and select still no result. no error
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]
awesome Suvrutt!,
thanks.
this [Materials].[Price] does the trick
Good to know it works. You may wish to take a look at the following article
will do. thanks
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |