3 Replies Latest reply on Nov 6, 2018 2:35 PM by Zhouyi Zhang

    Assigning a category field based on data

    S Kailay

      Hi all,

       

      I'm trying to assign a calculated "category" field based on the following logic (see attached workbook):

       

      • If there is data in both Month 1 and Month 2 then the category = Existing document
      • If there is data in Month 1 but Month 2 is Null then the category = Old document
      • If there is data in Month 2 but Month 1 is Null then the category = New document

       

      Is this do-able?

       

      Regards,


      Sandeep