Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have uploaded my problem through attachment,
if any one know could you please give explanation through expressions
Regards,
Niranjan B
Hi Niranjan,
//Count({$(=MonthStart(max(Month)))"}>} Empid)
not able to paste my answer
Hi,
It showing error after ending of month in the previous expression and one double quotes only present in your expression..If i tried to remove the double quotes, it showing error..what should i do to achieve this?
Count({"less than symbol"releaving_date={">$(=MonthStart(max(Month)))"}>} Empid). Somehow my answer is not displaying corretly "greate than symbol" with <
Here data showing correctly but as per requirement I want to show employee count one because of in may month one employee relived.when I choose multiple selection want to display current employee count, no need count of who are relieved employee's.
Hi Niranjan, Wat is the output when u have selected MAY,June? is it not 1 as expected?
as per requirement I want to show employee count one because of in may month one employee relived.when I choose multiple selection want to display current employee count, no need count of who are relieved employee's.
if select MAY month employee count 1,
if select JUN month employee count 1,
if select MAY and JUN employee count 1,because of in MAY month employee relived
Hi Niranjan, i'm clear on ur requirement. Please let me know the outcome of my formula
not getting correct result
=Count (DISTINCT { $ <Year={$(=(ma:@Year)))},Month={$(=MaxString(Month))} >} Emp_ID )
This is correct answer
=Count (DISTINCT { $ <Year={$(=(max(Year)))},Month={$(=MaxString(Month))}>} Emp_ID )
This is correct answer