Carbon Poker/Merge Rake Amount

[teodoras]

Hi,

I fount the following stat formula for calculating rake amount @ Carbon(it's weighted contributed apparently). However, the amounts calculated by this formula do not match the amounts in the daily rakeback report I get from Carbon. I play fixed limit, can anyone suggest how to accurately calculate my weighted contributed rake in PT3? I would then also like to add rakeback and VIP point totals in my player statistics section.

Here is the above mentioned formula I found on PT3 -

sum(if[holdem_hand_player_detail.amt_bet_ttl > 0 AND holdem_hand_summary.amt_rake > 0, holdem_hand_summary.amt_rake * (holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot), 0])

[kraada]

That's the only weighted-contributed formula I'm aware of. Is it too low or too high? Are there other things which might be affecting your rakeback?

[teodoras]

When I do 35% rakeback and VIP point calculations based on this formula both of those figures come up higher. I did take into account the fact that I'm accumulating VIP points at a 65% normal rake due to the rake back.

Also, another problem is that the totals for different limits do not add up correctly neither for rb nor vip points.

[WhiteRider]

We'll need to know exactly how your rakeback is calculated in order to build an accurate stat – can you find out from your site/affiliate exactly what calculations they do? If you could even get an example of how it would be calculated for a single hand that would help.

[teodoras]

So I re-entered all formulas and totals do come very close now, must have entered some portion of formula incorrectly somewhere.

However, still have two problems:

1. The amounts for different limits do not add up correctly, neither for rakeback nor VIP points, although when I add them up myself the totals are correct.

2. I created contributed rake stat in the Columns section under configure->stats->player statistics section. Then I added two new stats - Carbon Rakeback and Carbon VIP based on the contributed rake formula. In order to create a displayable stat for the Carbon Rake, I assume I would go under Statistics->New->Definition and enter the above formula for the value expression? What would I need to enter in the Format tab?

Thanks for all your help!

[teodoras]

Ok, managed to create the total rake paid stat.

Still can't get the totals to add up, here is what I mean -
[ img ]

[WhiteRider]

The way totals are calculated is defined by the Summary Type of the column.
For these you probably want it set to "Sum".

If you can't get it working please export your stats, compress and attach them to a Support ticket and we'll check them out.

[teodoras]

Yes, that did fix it! Problem solved, thank you for your help!

[WhiteRider]

Great - thanks for letting us know.

[pusaqall]

Yes, that did fix it! Problem solved, thank you for your help!

May I ask how were you able to fix this problem?[ img ]


_________________

Oh so good!! [ img ]