3 Replies Latest reply on Jan 9, 2019 2:34 PM by Anjali Sn

    Create calculated field to work on multiple columns from database

    Anjali Sn

      Hi,

       

      I have a column in my database as "Data_Type" which has values like following:

       

      GOALW2W3W4Data_Type
      =0.00001.000002.000002.400000Decimal
      >=99.5000098.5000098.5000098.50000Percent
      <10.0000098.5000098.5000098.50000Percent

       

      I want to create a calculated field such that when the value in the Data_Type field is 'Decimal' then it shows only till 2 decimal places (i.e., like 1.00, 2.00 ..) and when the value is 'Percent' then also with only showing till 2 decimal places, a percentage sign is also added (like 98.50%, 99.50%...). I want this calculated field to work on all the columns (i.e., GOAL, W2, W3, & W4). How do I achieve that?