Rakeback for a different timeframe (cashgame)

[kraada]

Try going a couple of days earlier and see if that makes any difference.

[damncute]

Awesome. That's it! I just needed to change the dates for one day and now it works perfect.

Thanks a lot for your help, kraada! Here's the final formular, maybe someone could use it too:

sum(if[cash_hand_summary.id_site=900 AND cash_hand_player_statistics.date_played <= 'January 08 2014'::timestamp,(((cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 0.38)), if[cash_hand_summary.id_site=900 AND cash_hand_player_statistics.date_played >= 'January 09 2014'::timestamp,(((cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 0.18)),0]])

Regards,
Chris