Guest User

Untitled

a guest
Oct 16th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. Fee Values:
  2.  
  3. fee_id ceiling percentage
  4. 12 50,000 25
  5. 12 75,000 12.5
  6. 12 125,000 7.5
  7. 12 <null> 1.5
  8.  
  9.  
  10. For 135,000:
  11.  
  12. Query Result:
  13.  
  14. base_total_in_this_bracket percentage_to_multiply_by final_total_in_this_bracket
  15. 50,000 1.25 12,500
  16. 75,000 1.125 9,375
  17. 125,000 1.075 9,375
  18. <null> 1.015 <null>
  19.  
  20.  
  21. Result should be:
  22.  
  23. base_total_in_this_bracket percentage_to_multiply_by final_total_in_this_bracket
  24. 50,000 1.25 12,500
  25. 75,000 1.125 3,125
  26. 125,000 1.075 3,750
  27. <null> 1.015 150
Add Comment
Please, Sign In to add comment