This content has been marked as final. Show 11 replies
I have two tables
Table A has Positions against a unique ID
Table B has Joining Status of the candidates against the unique Id created in Table A
Expression which is used to calculate the result is
SUM(positions)-count(if(candidate_status=1014, [budget_city_id-id] ,))
Now, the result which is coming is correct but with some zero values, Now i am not able to remove this Zero values. Please let me know i to do it.