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
    • 4 yrs agoWed, January 20, 2021 at 9:57 AM UTC
    • 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
    • 4 yrs agoThu, January 21, 2021 at 3:28 PM UTC
    • Reported - view

    Thanks ! Will try that.

    • mail.2
    • 4 yrs agoFri, January 22, 2021 at 5:29 AM UTC
    • Reported - view

    It works fine ;)