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

    Set Analysis for 2 Conditions

    Simon Hynd

      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

       

      Sum({$<NC-={"1200","2100","2150","2201",

      "2202","2011","2012","2013","0011","0012","0013","0020","0021","0030",

      "0040","0031","0041","0045","0046","1001","1010","1235","1230","1240",

      "1250","2200","3200","4001","1102","4010","1110","2101","2102","2301",

      "2310","2320","2325","3000","4013","4021","4022","4035","4030","4900",

      "4902","4903"}>}CR)

       

       

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