database.amt_rake represents whatever database value you're using to calculate your rakeback.
I dont get it.
Provide a example or a stat to download please.
I tried:
15% Rakeback partypoker = amt_rakeback_party15 =
I took the weighted contrib my currency conv column.
so i have to add the site check "AND cash_hand_summary.id_site = 200" here, right?
- Code: Select all
sum(0.15*CAST( (if[cash_hand_player_detail.amt_bet_ttl > 0, cash_hand_player_statistics.val_curr_conv * (cash_hand_player_detail.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake, 0]) AS numeric(11,2) ))
EDIT:
build it this way:
sum(0.15*CAST( (if[cash_hand_player_detail.amt_bet_ttl > 0 AND cash_hand_summary.id_site = 200, cash_hand_player_statistics.val_curr_conv * (cash_hand_player_detail.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake, 0]) AS numeric(11,2) ))
OK?