Reports

DECLARE @NetWorth DECIMAL(18, 2) = 488000
SELECT TotalCommission = CONVERT(DECIMAL(18, 2),
CASE WHEN @NetWorth <= 5000 THEN @NetWorth * 0.30 
        WHEN @NetWorth > 5000  AND @NetWorth <= 20000 THEN (5000 * 0.30) + (@NetWorth - 5000) * 0.35 
        WHEN @NetWorth > 20000 AND @NetWorth <= 50000 
                            THEN CASE WHEN ((@NetWorth - 5000) > 20000)
                                        THEN (5000 * 0.30)  + 
                                            (20000 * 0.35)  +  
                                            ((@NetWorth - 5000)- 20000)* 0.40
                                        ELSE (5000 * 0.30)+ (20000 * 0.35)
                                    END
    WHEN @NetWorth > 50000 
                            THEN CASE WHEN ((@NetWorth - 5000) > 20000)
                                        THEN (5000 * 0.30) +
                                            (20000 * 0.35) + 
                                            (50000 * 0.40) +
                                            ((@NetWorth - 5000) - 20000 )*0.45
                                        ELSE (5000 * 0.30) + (20000 * 0.35) + (50000 * 0.40)
                                END


END
)
79154500
