5 Replies Latest reply: Dec 19, 2014 2:07 PM by Anand Chouhan RSS

    Add a field based on another field

    Alam Nizami

        Hi,

       

      I am trying to add a filed that has a number for 'TimeReported' on a service desk ticket number.

       

      My table looks like this.

      Service Desk TicketTime Reported
      25222.5
      252224
      296125

      I want to add up Time Reported if the Service Desk Ticket number is the same, and only show one row instead of two separate rows.

       

      Can I do this in the script or maybe an expression for the table?

       

      any help is appreciated

       

      Thank you,

       

      Alam