4 Replies Latest reply on Nov 17, 2016 1:24 AM by Adarsh Srivastava

    Create a calculate field based on comparision of values

    Adarsh Srivastava

      Hi,

       

      I have some data like :

       

      NameMarks
      aaa50
      bbb40
      ccc65
      ddd45
      eee55
      fff85
      ggg

      90

       

      I want to create a calculated field considering marks of eee as benchmark such that it can give the results on comparing data like this :

       

      If Marks > marks of eee then 1 as output else 0. The output would look like this

       

      NameMarks
      Calculated field
      aaa500
      bbb400
      ccc651
      ddd450
      eee550
      fff851
      ggg

      90

      1

       

      I dont want to hard code the values.