Set Analysis

[tmumaw]

Need a little help on set analysis and ignoring null values.  Here is what I tried

Count({<Cont_Year -= {'-'},MGrp=>} total ServLoc)

It's giving me the total for both years and I need totals for 2017 and 2018 separately. Ignore the last column.

Here is what I am getting

[Anil_Babu_Samineni]

What if we can enable the option "Suppress" for MGrp ??

[sunny_talwar · Accepted solution]

May be this

Count({<Cont_Year -= {'-'},MGrp=>} TOTAL <Cont_Year> ServLoc)

[tmumaw]

Thanks Sunny.  I changed it to this and it worked.  Your help is appreciated.

Count({<MGrp=>} TOTAL <Cont_Year> distinct ServLoc)