rb + my C all-in Adj

[Renzo]

Hello,

I'd like to add my rakeback to my "My C All-in Adj" line (the line we get when we display the all-in equity line). I get 20% from partypoker, so I tried the following expression :

format_currency(amt_rake_weighted_contributed_curr_conv * .2, false, global_currency) + format_currency(amt_expected_won_curr_conv, true, global_currency)

But it doesnt work. I also tried to download and modify your merge stats but I didnt get anything neither. Could you tell me what's wrong with my expression?

When I get this line, is it possible not to see the green line anymore on my graph (the "My C won" line)?

Last question : do you know when the database schema documentation will be released?

Thank you

[kraada]

You want your value expression to be:

amt_rake_weighted_contributed_curr_conv * .2 + amt_expected_won_curr_conv

and then the format expression to be:

format_currency(amt_rake_weighted_contributed_curr_conv * .2 + amt_expected_won_curr_conv, true, global_currency)

and that should do it (just make sure to check Sum Results when adding it to the graph).

[Renzo]

Thank you for your answer kraada.

I have added a new column "amt_exp_won_and_rb" with the following expression : amt_rake_weighted_contributed_curr_conv * .2 + amt_expected_won_curr_conv
I guess this is my "value expression"

Then I have created a new stat with the foloowing expression : format_currency(amt_rake_weighted_contributed_curr_conv * .2 + amt_expected_won_curr_conv, true, global_currency)
I have also tried to create another stat with this expression : format_currency(amt_exp_won_and_rb, true, global_currency)

Both give me the good amount of money won in the statistics tab, that's great!
But I don't succeed in displaying the graph. When I have configured the "overlay stats" I have added my new stat, checked the "sum" box and clicked on "ok". It displays a linear line with my rb winnings only. So it's not the same amount than what I get in the statistics tab for the same stat. Any idea to get the graph?

[kraada]

You don't need to create a new column - in fact that might be causing you problems.

In your stat, make the Value Expression to : amt_rake_weighted_contributed_curr_conv * .2 + amt_expected_won_curr_conv and then set the format expression as you had it and then things should work better.

[Renzo]

Thank you, I have found the value expression box this time

Now I'd like to calculate my BB/100 for this new line on my graph. I have spent a few hours to make it but I didn't get anything good. What I have at the moment is :

value expression : amt_won_curr_conv + (amt_rake_weighted_contributed * .2)) / (cnt_hands / 100)

I need to express it in BB but I don't know how to do that. Or else I could create something like the "amt_bb_won" for my rakebcak, but I don't know how to make it neither.

Could you help me make this stat?

[kraada]

You'll need to make a new column for this one. That column would be:

amt_rake_weighted_contributed_bb and is defined as:

sum(CAST( (cash_hand_player_statistics.val_curr_conv * cash_hand_summary.amt_rake / cash_limit.amt_bb) as numeric ))

Then your stat is:

(amt_expected_bb_won + amt_rake_weighted_contributed_bb * .2) / (cnt_hands / 100)