3 Replies Latest reply: Apr 25, 2017 3:42 AM by Tresesco B RSS

    AND condition in Set Analysis

    Phil Speight

      Hi

       

      I have a set analysis which works fine.

      As per below :

       

      (count({<

      Leavers.Leaving_Reason-={'Flexi Retirement'},

      Dates.FiscalYear={'15/16'}

      >} Leavers.Leaving_Reason))

       

       

      I now need to exclude any Fixed Term Contract staff but only exclude 'Medical & Dental' staff from the fixed term contract leaving reason.  I tried the below, but it doesn't work.

       

      (count({<

      Leavers.Leaving_Reason-={'Flexi Retirement'},

      Leavers.Leaving_Reason-={'Fixed Term Contract'} and [Staff Group]={'Medical and Dental'},

      Dates.FiscalYear={'15/16'}

      >} Leavers.Leaving_Reason))

       

       

      Any help appreciated.

       

       

      Thanks

       

       

       

      Phil