USP_KPI_REVENUE_SELECTIONMONEYTOTAL_INTERNAL

            CREATE procedure dbo.USP_KPI_REVENUE_SELECTIONMONEYTOTAL_INTERNAL

            @ASOFDATE datetime,
            @TOTAL money = 0 output,
            @AGGREGATENAME nvarchar(10) = 'SUM' --Possible values SUM,AVG,MIN,MAX


            as    

            set nocount on;

            if @AGGREGATENAME='SUM'
                select @TOTAL = coalesce(SUM(FT.BASEAMOUNT), 0) from dbo.FINANCIALTRANSACTION AS FT        
                /*#IDSETEXTENSION*/
                where FT.DATE <= @ASOFDATE
                and FT.TYPECODE in (0,1,2,3,4,5,6,7,8,9) and FT.DELETEDON is null

            else if @AGGREGATENAME='AVG'
                select @TOTAL = coalesce(AVG(FT.BASEAMOUNT), 0) from dbo.FINANCIALTRANSACTION AS FT                
                /*#IDSETEXTENSION*/
                where FT.DATE <= @ASOFDATE
                and FT.TYPECODE in (0,1,2,3,4,5,6,7,8,9) and FT.DELETEDON is null

            else if @AGGREGATENAME='MIN'
                select @TOTAL = coalesce(MIN(FT.BASEAMOUNT), 0) from dbo.FINANCIALTRANSACTION AS FT                
                /*#IDSETEXTENSION*/
                where FT.DATE <= @ASOFDATE
                and FT.TYPECODE in (0,1,2,3,4,5,6,7,8,9) and FT.DELETEDON is null

            else if @AGGREGATENAME='MAX'
                select @TOTAL = coalesce(MAX(FT.BASEAMOUNT), 0) from dbo.FINANCIALTRANSACTION AS FT                
                /*#IDSETEXTENSION*/
                where FT.DATE <= @ASOFDATE
                and FT.TYPECODE in (0,1,2,3,4,5,6,7,8,9) and FT.DELETEDON is null
            else 
                BEGIN
                    SET @TOTAL =0;
                    RAISERROR('Valid values for @AGGREGATENAME are SUM, AVG, MIN, and MAX.',16,10);
                END