0

Filter / compare two fields

How can i using the filter option, only see those records where two specified fields are not equal. Which line should i type in the filter field.

Tried some things, but did'nt work out.

Thanks !

3 replies

null
    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    In the tabular view, I would add a new "Formula" column, with the formula "field1 = field2". It then suffices to define a filter on that column, in this case with the value "No".

    • mail.2
    • 3 yrs ago
    • Reported - view

    Thanks ! Will try that.

    • mail.2
    • 3 yrs ago
    • Reported - view

    It works fine ;)

Login to reply

Content aside

Categories

View all topics
  • 3 yrs agoLast active
  • 3Replies
  • 410Views