Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
count({<[Year]={$(=max([Year])-1)}>}EMP_STATUS='A')
in the above statement i m trying to count emp_status value A for perivous year .
is it correct ?
no,
Correct is as below.
count({<[Year]={"$(=max([Year])-1)"},EMP_STATUS={"A"}>}EMP_STATUS)
Regards,
Kaushik Solanki
no,
Correct is as below.
count({<[Year]={"$(=max([Year])-1)"},EMP_STATUS={"A"}>}EMP_STATUS)
Regards,
Kaushik Solanki
I don't thinkk that would be ok, I would do it as follow:
count({<EMP_STATUS={'A'},[Year]={$(=max([Year])-1)}>}EMP_STATUS)
what if we want to calculate for the same year
what if we want to calculate for the same year
It will be
count({<EMP_STATUS={'A'},[Year]={$(=max([Year]))}>}EMP_STATUS)
it should looks like below:
count( {< EMP_STATUS = {'A'}, [Year] = {"$(=Max([Year]))"}>} EMP_STATUS )
can i get tutorial/training guide for this ?
can i get tutorial/training guide for this ?
HI,
PFA,