Appreacite your help to figure out this. I need to create an expression so that when at least a record is created either on the device table or in the Materials table, a virtual column in the Task (parent table) gives a message.
I am trying this expression, but is always returning false even though there a records in the child table:
IF(
OR(
COUNT(SELECT(Dispositivos[HARDWARE ID], [HARDWARE ID] = [_THISROW].[id])) > 0,
COUNT(SELECT(Materiales[MATERIAL ID], [MATERIAL ID] = [_THISROW].[id])) > 0
),
"Please Check",
"Nothing to check"
)
Solved! Go to Solution.
I assume they are both child tables for the Task, then use something like..
IF(COUNT([Related Devices])+COUNT([Related Materials])>0,..)
I assume they are both child tables for the Task, then use something like..
IF(COUNT([Related Devices])+COUNT([Related Materials])>0,..)
Thank you so much! It worked.
You're welcome!
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |