11 Replies Latest reply: Mar 27, 2017 11:24 AM by omar bensalem RSS

    I want to remove Zero's from my report but i am not able to do it

    Pratik Jain

      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.