UFN_MEMBERSHIPTRANSACTION_CALCULATETOTAL

                create function dbo.UFN_MEMBERSHIPTRANSACTION_CALCULATETOTAL
                (
                    @ID uniqueidentifier
                )
                returns money
                as begin    
                    declare @TOTAL money = 0
                    set @TOTAL = coalesce((
                        select sum([REVENUESPLIT].[AMOUNT]) 
                        from dbo.[MEMBERSHIPTRANSACTION] 
                        inner join dbo.[REVENUESPLIT] 
                            on [MEMBERSHIPTRANSACTION].[REVENUESPLITID] = [REVENUESPLIT].[ID] 
                        where [MEMBERSHIPTRANSACTION].[ID] = @ID)
                        ,0)

                    return @TOTAL;
                end