Advertisement
Guest User

Untitled

a guest
Feb 25th, 2020
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. CASE WHEN "BM2"."Wise Transactions"."Claim Amount" - "BM2"."Goal Locations and Numbers"."Minimum Rev Target" > 0
  2. THEN CASE WHEN "BM2"."Goal Locations and Numbers"."Goal Service Code" = 'MAP'
  3. THEN CASE WHEN TRUNCATE ( "BM2"."Wise Transactions"."Claim Amount" / "BM2"."Goal Locations and Numbers"."Rev Increments" ,0)* "BM2"."Goal Locations and Numbers"."Rev Increments" = "Pulse MHS"."MAP Bonus Lookup"."TOTAL_MONTH_REVENUE"
  4. THEN "Pulse MHS"."MAP Bonus Lookup"."BONUS_AMOUNT"
  5. ELSE CASE WHEN "BM2"."Wise Transactions"."Claim Amount" > MAX("Pulse MHS"."MAP Bonus Lookup"."TOTAL_MONTH_REVENUE")
  6. THEN MAX("Pulse MHS"."MAP Bonus Lookup"."BONUS_AMOUNT")
  7. ELSE 1
  8. END
  9. END
  10. ELSE (( "BM2"."Wise Transactions"."Claim Amount" - "BM2"."Goal Locations and Numbers"."Minimum Rev Target")/"BM2"."Goal Locations and Numbers"."Rev Increments" ) * "BM2"."Goal Locations and Numbers"."Bonus Increment - Fixed Amount"
  11. END
  12. ELSE 0
  13. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement