Compare Employee Status in Comparison Month and Reporting month

[Anonymous]

Hi All,

I am facing issue while comparing Employee status from Comparison Month and reporting month.

1) Comparison Month- User will select any month from drop down of months at UI Level and same will be used for all formulae

2) Reporting Month- Latest month from database/Max Month

I have to check all employees count who were at OFFSHORE in Comparison month and Onsite in Reporting month.

I have tried many formulae but no success.

Below is the one for reference:

count({<CALMONTH={$(=$(vReportingMonth))},OnOffClassification={'ONSITE'},Employee=P({

aggr( {<ComparisonMonth=>}

count({<CALMONTH={$(=$(vComparisonMonth))},OnOffClassification={'OFFSHORE'},ComparisonMonth=>}Employee),Employee)}

>}Employee)

Can anyone help me here to resolve it.

Thanks in advance.

Vivek