2 Replies Latest reply on Jul 26, 2016 11:18 PM by Sapir Tayri

    Split one column to two columns by flag

    Sapir Tayri

      Hi,

       

      I have one column called 'Data Code' (with codes of data type: 1,2,3 etc.) and another column called  'Data Desc' (with description of data : Sales, Budget, Logistic cost etc.) .

      1=Sales

      2=Budget

      3=Logistic cost ...

      (And another column with the amounts , of course...)

      And want to make calculations between Sales and Budget, Logistic cost and so on...

      Can I calculate between them on one column, or should i split them and then make calculations?

       

      Thanks,

      Sapir