10 Replies Latest reply on Apr 24, 2018 10:39 AM by Saikrishna Mamidi

    switching the version based on Data

    Saikrishna Mamidi

      Hi All,

       

      In the Below Dataset, I would like to use Val-B' values for years 2016, 2017. As version B does not exist for 2018, I would like to use val-A.  How to achieve my requirement. Actually, it is like,  If Version B exits then use Val-B, else use Val-A.  Kindly give idea to achieve this in Calculated field,  Users are not interested to have Parameter to select val-A or val-B.  Thank you in Advance.

       

      YearVersionVal-AVal-B
      2016A10
      2016B20
      2017A40
      2017B15
      2018A59

      I have simplified data set for understanding, the actual column for Year is complete Date (DDMMYYYY).