6 Replies Latest reply on Mar 24, 2017 10:50 AM by Deepak Rai

    can't mix aggregate and non-aggregate comparisons or results in 'IF' expressions

    Michelle Kosmicki

      I have a lovely IF statement that is using a T|F boolean and a calculated measure.  They don't want to work together.

       

      I have tried various things like doing the calculated measure in the IF statement, using CONTAINS() instead of the Boolean, and can't seem to get this to budge.

       

      Suggestions?

       

      Michelle