I need to find out the No of Non Performing Dealers who having Zero Sales ?? Can any One give me Idea??
Thanks in advance
To get a count of the dealers with 0 sales i have used :
To get a list of the dealer names this expression may solve your problem:
or if( count(sales)=0,1,Sales)
if(sales=0 or sales=' ',Dealers)
Retrieving data ...