Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CASE WHEN "BM2"."Wise Transactions"."Claim Amount" - "BM2"."Goal Locations and Numbers"."Minimum Rev Target" > 0
- THEN CASE WHEN "BM2"."Goal Locations and Numbers"."Goal Service Code" = 'MAP'
- 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"
- THEN "Pulse MHS"."MAP Bonus Lookup"."BONUS_AMOUNT"
- ELSE CASE WHEN "BM2"."Wise Transactions"."Claim Amount" > MAX("Pulse MHS"."MAP Bonus Lookup"."TOTAL_MONTH_REVENUE")
- THEN MAX("Pulse MHS"."MAP Bonus Lookup"."BONUS_AMOUNT")
- ELSE 1
- END
- END
- 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"
- END
- ELSE 0
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement