Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Need Salesman Count, when his sales is '0' in current and previous month.
Below expression not work, it showing count individual. Check the sample data.
Any leads appreciate.
Count(distinct{<[Win Count]={'$(=Aggr(Sum([Win Count]),link_Salesman)=0)'},
link_Date={">=$(vLast2MonthsStart)<=$(vCurrentDate)"},[Fiscal Year]=,[Fiscal Quarter]=,[Fiscal Month]=>} link_Salesman)
TIA
Hi,
When I used the below expression using the sample data you have provided, I got 2 as the answer. Is this what you are looking for?
Count({<[Salesman Name]={"=Sum([Win Count])=0"}>} Distinct [Salesman Name])
I didn't add date filter since your data is already is filtered with current and previous month.
Hi,
When I used the below expression using the sample data you have provided, I got 2 as the answer. Is this what you are looking for?
Count({<[Salesman Name]={"=Sum([Win Count])=0"}>} Distinct [Salesman Name])
I didn't add date filter since your data is already is filtered with current and previous month.