Cereus Rake calculations

[wernerw]

Maybe somebody has already done similar:

I want to create a report where I can see my (players) raked hands and contributed rake (which will lead to my rakeback).

My optimum report would contain:
- total hands
- raked hands
- My rake
- 30% of my rake
- tablehours

Very nice would be to see these numbers as a total and per limit.

Definitions done by Cereus (hope this is correct, i contacted support about it):

Raked hand:
Any hand where I put money in and Cereus is taking a rake. Hands where I only paid blind do count.

My rake:
Rake taken by Cereus divided by the players that put money in. Rake for Bad Beat Jackpot should not be included.

Does anybody have such a report already? This is my first attempt to do anything like that in PT3 and a hint of a starting point would be great. I should be able to succeed since I have programming experience.

[WhiteRider]

Here is my cnt_contrib_raked_hands column:
sum ( if[ holdem_hand_player_detail.amt_bet_ttl > 0 AND holdem_hand_summary.amt_rake > 0, 1, 0 ] )

This counts how often a player bet more than 0 in a hand and the rake was more than 0.
You can then create a statistic to show this count.

Have a look at the Custom Statistics and Reports FAQ and see if you can build your stats.
If you get stuck, please post back and let us know your problem.