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