9 Replies Latest reply on Aug 3, 2017 10:38 AM by Radi Saran

    If condition - column value look up

    Radi Saran

      I have the following scenario:

       

      I have two calculated fields and date column 

       

      NameSIGN DATECalc 1Calc 2Year Difference
      AAA02/5/151321432
      BBB2/4/171391450
      CCC10/29/141421763

       

      Now I have to create a formula where

      if year difference < 1 , then calc3 = calc1

      else calc 3 = calc 2

       

       

      Desire output:

       

      NameSign Datecalc 3
      AAA02/5/15143
      BBB2/4/17139
      CCC10/29/14176

      How can I do this in Tableau?