This app has a table called pre start in which machines are inspected.
Another table called Risk assessment in which machines are inspected.
Obviously these tables cover different aspects to inspect.
I am trying to format the risk assessment UX.
I have this:
Tick means it passed the risk assessment
Cross means it failed
Exclamation mark means the machine has moved location since last assessed and requires a new assessment.
Both tables referred to above use Timestamp as the key column, Equipment to identify the equipment and Site to refer to the location.
My issue arises with the exclamation mark expression.
It should be asking:
Risk assessment [Site] = Pre Start[Site]
The expression I have so far:
([_THISROW].[Equipment] = [Equipment]))),
This results in the image above.
This is incorrect as it should look like this: