Set analysis as well as matching text/numbers

[#1]

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?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Easier than it seems!

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

That will check for all values starting by "12"

Hope that helps,

Miguel