4 Replies Latest reply: Sep 1, 2016 12:13 PM by Sunny Talwar RSS

    Set Analysis for 2 Conditions

      I'm trying to create a sum calculation based on a field (NC) not equalling certain criteria ("1200,2100,2150 .......") and field (F4) = "PI"


      I've managed to get the 1st criteria to work using the expression below but I'm not sure how to include the AND F4 = "PI" bit










      Any ideas please, I've tried what I thought but just keep getting 'Error in Expression' messages whenever i try anything