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

    calculated field for data at granular level


      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