1 Reply Latest reply: Oct 19, 2016 1:31 PM by Gysbert Wassenaar RSS

    display rows only when fields from two tables are equal

    Margaret Martin

      I have a field in one table called DocDate and a field in another table called AuditDate. Can I create a Listbox with 'Y' & 'N' (or other object) so that my chart (which contains data from both tables) displays only rows where DocDate = AuditDate?

       

      I tried this as an Expression in a ListBox:


           =if(DocumentDate = AuditDate, 'Y', 'N')

       

      But it doesn't work.