4 Replies Latest reply on Jun 3, 2013 1:25 PM by Andrew Ball

    calculated field for data at granular level

    siddhartha.siddhartha


      Hi All

       

      I have this fieild which has value like:

       

      Event Name       Amount

      I                            5

      E                           6

      R                          2

       

      I need to sum up the amount according to this rule i.e when event is I it should 5+6+2 when it is E it should be 6+2 and when it is R it should be 2.

       

      Please suggest me the case or if statement for this.

       

       

      Thanks Sid