SHARE
TWEET

Untitled

a guest Feb 25th, 2020 95 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top