Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
count({< Issue = {'[Internal Privacy incident]'}, Month={">=$(=MonthStart(AddMonths(Max(Month),-3)))<=$(=MonthEnd(Max(Month))) >} Issue)
Hi Ravi,
I assume Month is Dual Field
Try
count({< Issue = {'Internal Privacy incident'}, Month={'>=$(=Max(Month)-3)'}>} Issue)
Regards,
Antonio
Also have a look at
If you still have problems with your set modifier, please post the exact format specifier of your Month field.