8 Replies Latest reply on Jul 3, 2018 6:55 AM by john.cho.1

    Creating Calculated Field Based on Two Values in a Single Column

    john.cho.1

      Hello,

       

      We have a table that's structured like below:

       

      DateValueCategory
      7/1/201810iOS
      7/1/201820Android
      7/1/201815Web
      7/2/201815iOS
      7/2/201830Android
      7/2/201825Web
      7/3/201840iOS
      7/3/201810Android

       

      How do I create a calculated field based on two values in the category column? For example, I would like build a calculated field that calculates the value sum of iOS and Android.

       

      Thanks.