3 Replies Latest reply on Aug 14, 2018 2:48 AM by meenu choudhary

    Split a field and add into different fields

    kaumudi nidumolu

      hello all!

       

      after extensive researching, i havent found a solution yet.

      so my issue is as follows:

      i have a table that looks like this, with value as a measure and category is a dimension

       

      categoryvalue
      a10
      b20
      c30

       

      so i need to split b into two parts 90% of the value and 10% of the value

      now we add the 10% value of b to c and 90% value of b to a

      so the final table would Need to look like this:

      Categoryvalue
      a10+18
      c30+2