Forum Discussion

BradonK's avatar
BradonK
Frequent Visitor
9 months ago
Solved

How to Find Rows Missing from Table by Date

Hi,   I am trying to create a report that takes two tables. One is a list of breathalyser readings by date. The other is a list of signatures on a form by date. Below is an example. Breathalyser D...
Need Help
  • Arul's avatar
    Arul
    9 months ago

    BradonK ,

    try this in calculated column,

    VAR a1 = EXCEPT(Signatures,Breathalyser)
VAR a2 = EXCEPT(Breathalyser,Signatures)
VAR output = UNION(a1,a2)
RETURN output
Arul's avatar
Arul
Super User
9 months ago

BradonK ,

try this in calculated column,

VAR a1 = EXCEPT(Signatures,Breathalyser)
VAR a2 = EXCEPT(Breathalyser,Signatures)
VAR output = UNION(a1,a2)
RETURN output
  • BradonK's avatar
    BradonK
    Frequent Visitor
    9 months ago

    Hi,

     

    Thanks all for your answers and quick responses.

    Apologies I did not get back to this sooner, I have had limited time to work on this.

     

    Arul your answer did exactly what I needed, returning a list of names that were on one list but not he other. Thanks again for your help.

     

    Cheers