4 Replies Latest reply: Jul 18, 2017 12:39 AM by Divyanshi Bansal RSS

    How to Merge 2 columns Year filed into one?

      Dear All,


      I get my data from 2 table sources, so one is suppose is called AExpiredDate and another one is BExpiredDate

      so i wish to display these two in to one instead.


      for example data source A

      AExpiredDate    Amount

      --------------------    --------------

      2012/02/03           12


      BExpiredDate   Amount

      ---------------------   ---------------

      2012/03/03           8


      So, i wish to get my result like below

      ExpiredYear      Amount

      -------------------    ----------------

      FY2012                 20


      The Dimention i written something like this.. :

      if((Var_Tenant_Name<>'Vacant' and Var_Tenant_Monthly<>'Y') ,'FY' & Year(Var_Tenancy_Expiry),

        if(Var_Tenant_Name<>'Vacant' and Var_Tenant_Monthly<>'N','Monthly Tenancy' ))


      how am i going to merge this two different field into one?


      Hope to hear from the solution..