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

       

       

      Regards

       

      Muhammad