4 Replies Latest reply: Nov 23, 2016 4:43 AM by Girish Chhatani RSS

    Issue related to First Sorted Value

    Girish Chhatani

      Hey friends,

       

      Facing issue while calculating Statement Amount using FirstSortedvalue()

          

      Transaction IdValue DateBank codeAmount_1Amount_2Posting DateBranch Code
      BA0030160921-01921-09-2016BA0030250002500001-10-2016B0060
      BA0030160921-01921-09-2016BA003025000001-10-2016B0180

       

       

      Master Table:-

      Transaction IdValue DateAmount_1
      BA0030160921-01921-09-2016250000

       

      Transaction Table:-

      Transaction IdBranch CodeUser ID
      BA0030160921-019B0060SHANKARR
      BA0030160921-019B018033199

       

      Expected Output

      Transaction IdValue DateBank codeAmount_1Amount_2Posting DateBranch Code
      BA0030160921-01921-09-2016BA0030250002500001-10-2016B0060
      BA0030160921-01921-09-2016BA00300001-10-2016B0180

       

      Because Amount_1 is 25000 against the given Transaction Id.

       

      Please help me out.

       

      Girish Chhatani