3 Replies Latest reply: Oct 15, 2015 5:06 PM by David Freschl RSS

    using "OR" in Set analysis

    Mark Graham

      Hi all,

       

      I was trying to use '+' in the place of OR in the set analysis:

      Can some one help me on this:

      If Name is ABC or XYZ and City is Paris, i was trying to sum the salary using Set analysis:

       

      Trying for Set analysis for the below statement:

       

      =Sum(If((Name='ABC' or Name='XYZ') and City='Paris', Salary))