7 Replies Latest reply on Aug 17, 2016 5:34 AM by Muhammad Khan

    Need Correction In Formula

    Muhammad Khan

      Hello Everyone


      I have two different dimensions

                1) Employer 

                2) Job Status with Values "Open" , "Applied" , "Closed" and "Filled"


      I want count of Employer but want those who's jobs are still open. I am applying below formula but there is something wrong with it.


      COUNT([Employer])  IF (([Job Status] = 'Open') OR ([Job Status] = 'Applied')) END



      Your help will be highly appreciated