8 Replies Latest reply: Apr 15, 2014 2:42 AM by ashok Velisetty RSS

    How to calculate Bill type summation?

    ashok Velisetty

      Hi ,

       

      I have data like below

       

       

      DateBilltypeQueueLOBValue
      4/1/2014UBDEA10
      4/1/2014B20
      4/1/2014VERC30
      4/1/2014HCFADEA1
      4/1/2014B2
      4/1/2014C3

       

      i need result like below

       

      DaeBilltypeQueueLOBValueResult
      4/1/2014UBDEA1060
      4/1/2014B2060
      4/1/2014VERC3060
      4/1/2014HCFADEA16
      4/1/2014B26
      4/1/2014C36