Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I would be thankful if you tell me the awnser ^^
I should to find the total of rookies in the company, So here the calculation :
new year= current year-2
if new year >= 2 , count PERSON_ID where PERSON_TYPE_ID={6}
please help me i couldn't found it
May be this?
count ({<PERSON_TYPE_ID={6}, year={'$([new year])'}>} PERSON_ID)
Thank You very much ..
but may be i didn't explain my problem very well..!!
I have to count the total number of rokkies in the company so i have these data:
1- count({<PERSON_TYPE_ID={6}>}distinct PERSON_ID) . (These for count Total employees)
2- I should subtract from Current Date -2
3- I should subtract Current date from Date Start if the result >=2 then count it as rookies
DateStart-Current date >=2 ,Count ({<PERSON_TYPE_ID={6}>}distinct PERSON_ID)
How can I solve it could you please help me!