Forums › Cached › Customization › Searches / List Views

This topic contains 2 replies, has 0 voices, and was last updated by samzad 9 years, 1 month ago.

  • Author
    Posts
  • September 22, 2015 at 1:40 pm #5462 Score: 0

    samzad
    • Contributions: 0
    • Level 1
    • ☆

    Hi Guys

    I was trying add a formula(Text) to save search to compare two fields by using standard not equal SQL expression <> or != with CASE statement but having Error: invalid Expression. Any idea on how to accomplish this? appreciate your help.

    Thanks

    Sam
    This is a cached copy. Click here to see the original post.

  • September 22, 2015 at 3:09 pm #5463 Score: 0

    Sireesha
    • Contributions: 0
    • Level 1
    • ☆

    Hi,

    This is the syntax

    CASE WHEN ( {field1} != {field2} ) THEN 1 ELSE 0 END

    Hope it helps.

    Regards,

    Sireesha

  • September 29, 2015 at 2:52 pm #5464 Score: 0

    samzad
    • Contributions: 0
    • Level 1
    • ☆

    thanks a million

  • Author
    Posts

You must be logged in to reply to this topic.