Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Fee Values:
- fee_id ceiling percentage
- 12 50,000 25
- 12 75,000 12.5
- 12 125,000 7.5
- 12 <null> 1.5
- For 135,000:
- Query Result:
- base_total_in_this_bracket percentage_to_multiply_by final_total_in_this_bracket
- 50,000 1.25 12,500
- 75,000 1.125 9,375
- 125,000 1.075 9,375
- <null> 1.015 <null>
- Result should be:
- base_total_in_this_bracket percentage_to_multiply_by final_total_in_this_bracket
- 50,000 1.25 12,500
- 75,000 1.125 3,125
- 125,000 1.075 3,750
- <null> 1.015 150
Add Comment
Please, Sign In to add comment