by WhiteRider » Thu Jul 10, 2008 11:41 am
EDIT: Please note that while this will work in some situations this kind of stat will not work properly and may cause problems with housekeeping so THIS IS NOT RECOMMENDED.
OK, it's not the simplest example this, but I think I've made it.
The total money won is already available as a built-in statistic, but it is in the wrong section to be shown on the HUD (it is defined in 'Holdem Tournament Tournaments', whereas the stats shown on the HUD are taken from section 'Holdem Tournament Player Statistics').
So we need to recreate this statistic in the correct section.
1. Configure -> Configure Stats.
2. Choose section 'holdem tournament player statistics'
Create a couple of new columns:
3. Click 'Columns' tab. Create new colums... Make sure you save each one.
3a. "amt_money_won". Enter this in the Expression:
sum(tourney_holdem_results.amt_won)
3b. "amt_buyin_ttl". Enter this in the Expression:
sum(tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon)
(I copied this from the Column of the same name in the 'holdem tournament tournaments' section.
We now create a variable to hold the net amount won, using the 2 columns we just created.
4. Click 'Variables' tab.
4a. Enter a new variable called "amt_net". Enter this in the Expression field:
amt_money_won - amt_buyin_ttl
Make sure you click Save.
We can now create the Statistic.
5. Click 'Statistics' tab.
5a. Create a new Statistic called "Money Won Net". Enter this in the Expression:
amt_net
(this is the variable we just created)
5b. Click the 'Format' tab on this stat, and fill in the fields, e.g. Title="$Net", width=80. Enter this in the 'Format Expression' field and 'Format Summary Expression' (same in both).
format_money( amt_net, true )
5c. On the 'Categories' tab you may want to include the stat in 'Money' and maybe 'Results'.
Again, click Save.
The "Money Won Net" statistic should now be available to be added to Custom Reports, and to the tournament HUD.