1 Reply Latest reply: Oct 11, 2012 12:08 PM by Miguel Angel Baeyens de Arce RSS

    Set analysis as well as matching text/numbers

      I have a set analysis expression

       

      sum

      ({$<[Date] = {">=$(=addmonths(max(Date),-$(vSelectNoOfMonths)+1))<=$(=max(Date))"}>}[Accidents Count ID])

       

       

       

       

      The above is working fine but I wish to further filter the analysis by only having the above for records where a field 'Immediate Cause' is populated by a number of values such as '12i', '12j','12k' etc etc. I have tried adapting the like/match commands but cannot combine those with the set analysis expression above

       

      Any ideas please?