My source table is Work
Destination table is Device
I want to get all the devices where Monitor = "New" and get a count of all of them to be displayed.
How can I do it through lookup expression
. I tried the one below , but doesn't look correct...
Any Advises.
=
LOOKUP(Field!DeviceName,Field!Device_Name,Field!Monitor="New","Device")