Set analysis

[Anonymous]

Can someone please assist me on below issue.

Coding:  in below code first condition only working (ex. Issue = Internal privacy incident only working, another condition Month conditions is not working)

count({< Issue = {'Internal Privacy incident'}, Month={">=$(=MonthStart(AddMonths(Max(Month),-3)))<=$(=MonthEnd(Max(Month))) >} Issue)

[effinty2112]

Hi Ravi,

                    Loks like you've omitted a ".

Try this :

count({< Issue = {'Internal Privacy incident'}, Month={">=$(=MonthStart(AddMonths(Max(Month),-3)))=$(=MonthEnd(Max(Month)))" >} Issue)

Cheers

Andrew

[Anil_Babu_Samineni]

count({< Issue = {'[Internal Privacy incident]'}, Month={">=$(=MonthStart(AddMonths(Max(Month),-3)))<=$(=MonthEnd(Max(Month))) >} Issue)

[antoniotiman]

Hi Ravi,

I assume Month is Dual Field

Try

count({< Issue = {'Internal Privacy incident'}, Month={'>=$(=Max(Month)-3)'}>} Issue)

Regards,

Antonio

[swuehl]

Also have a look at

Dates in Set Analysis

If you still have problems with your set modifier, please post the exact format specifier of your Month field.