3 Replies Latest reply on Aug 20, 2013 5:05 AM by Shawn Wallwork

    Based on the answer of one column, change answer in another column

    Ali Hirji

      Hi all,

       

      I was wondering if anyone could help with a formula. I have the below set of results (please see table below) and what I would like to have is a formula that if the Candidate_RighttoWork_NotApplicable (column 2) equals 0 return the Candidate_RighttoWork_YesNO - and if it's 1, then display N/A.


      CandidateNotApplicable.jpg


      Cheers,


      Tableau AdministratorBrandon WhiteheadJive MonitoringTableau AdministratorKelly OsterhoutJulia RyanOzgu Tokgoz