Mapping two dates in set analysis

[Anonymous]

Hi All,

I have a requirement to map dates in UI scripting ,How to add Rating year in below set analysis

when 201703 and onwards  month_year selected rating year should be 2016  else it should be 2015:

Count({<[Month_Year] = {'$(vMaxMonthYear)'}>} [Employee Count])

Month_Year	Rating Year
201603	2015
201604	2015
201605	2015
201606	2015
201607	2015
201608	2015
201609	2015
201610	2015
201611	2015
201612	2015
201701	2015
201702	2015
201703	2016
201704	2016

Any help is appreciated.

Thanks & Regards

Neetha

[sunny_talwar]

May be this

Count({<[Month_Year] = {'$(vMaxMonthYear)'}, [Rating Year] = {$(=If(Max(Month_Year) >= 201703, '2016', '2015'))}>} [Employee Count])

[Anonymous]

Hi Sunny,

Thanks for quick response, quiet modified your syntax:

=If(Max(Month_Year) >='$(vMaxMonthYear)' , Max(RYear), Max(RYear)-1)  - This works

=Count({<[Worker Status]= {'$(vWorkerstatus_Inactive)'}, [Termination Count] = {1}, [Month_Year] = {'$(vMaxMonthYear)'},[Rating Year]  = {$(=If(Max(Month_Year) >= {'$(vMaxMonthYear)'}, Max([Rating Year] ), Max([Rating Year] )-1))}>} [Employee Count])  - but this  doesn't work.

Thanks

Neetha

[sunny_talwar · Accepted solution]

Why the curly brackets? May be this

=Count({<[Worker Status]= {'$(vWorkerstatus_Inactive)'}, [Termination Count] = {1}, [Month_Year] = {'$(vMaxMonthYear)'},[Rating Year]  = {$(=If(Max(Month_Year) >='$(vMaxMonthYear)' , Max(RYear), Max(RYear)-1))}>} [Employee Count])