1 Reply Latest reply on Jul 16, 2013 8:20 AM by philmodjunk

    Sum of records outside the self-join.

    ABin

      Title

      Sum of records outside the self-join.

      Post

           Hi All, 

            

           I would appreciate an insight in this 

            

           I have a table Transaction with the following fields

           Date

           Opening Balance (Global)

           Past Opening Balance (Calculated)

           Transaction Value

           Date From (Global)

           Date To (Global)

           InRange (Calculated ) 

           MATCH_IN_RANGE ( Global = IN RANGE )

           -- What happens if the the user selects a date range value the "In Range" calculated fields upon a self join becomes IN RANGE and values that fall in the range appear. 

            

           I already have the system opening balance stored in "Opening balance". What I would like to have is Past Opening balance to calculate opening balance upto the Date FROM. 

            

           I tried a self join again using a match for transaction occuring before Date From. But it did not work. 

            

           Thanks in advance.

        • 1. Re: Sum of records outside the self-join.
          philmodjunk
               

                    I tried a self join again using a match for transaction occuring before Date From. But it did not work.

               That should have worked.

               I think we need to see all the relationship details for how you determine that a given record is "in range" before we go any further. (I know of two ways to get that to work with a self join).