3 Replies Latest reply: Dec 12, 2016 3:51 AM by Kaushik Solanki RSS

    If to case conversion

    Ravikiran Pat

      Hi Anyone,

       

      Can please convert the IF code to case.

       

      If(columnA='RAV', If(columnC> 9, 'RAV After 7 Days', 'RAV Till 7 Days'),

      If(columnA='TOT/ODv', If(columnB='OVD', If(columnC> 5,'OVD After 3 Days', 'OVD Till 3 Days')

      ,'TOT'), columnA)) AS New,