[MTT] Resultscolumn with total Buy-Ins and Total Fees needed

[ElHive]

Right now for the tournament results there are only columns for "Buy-In + Fee", "Buy-In only" and "Fee only" available. But they don't include reentries. So If I played 12 Tournaments and have taken 12 reentries, so 24 entries total, the "Buy-In only" and "Fee"-Column does not include the 12 reentries.

I tried creating a stat that multiplies "Buy-In only" or "Fee" with "Rebuys" to get columns with information I need. But the value in the summery line at the bottom was totally wrong.

What do I need to do to create a column for "Fee" and/or "Buy-In only" that includes the reentries taken during a tournament?

[Flag_Hippo]

There are built-in statistics you can use to display the total amount spent - 'My Currency Cost' or 'Game Currency Cost'.

[ElHive]

Ok, that helps but I'm not quite there yet. I want something like amt_fee_ttl

So I took amt_buyin_ttl and edited it from

Code: Select all

sum(tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon +
tourney_summary.amt_bounty )

into

Code: Select all

sum(tourney_summary.amt_fee + tourney_summary.amt_fee * tourney_results.cnt_rebuy)

I also need this in My Currency so I also took amt_buyin_ttl_curr_conv and edited it from

Code: Select all

sum(if[tourney_summary.val_curr_conv != 0, tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon +
tourney_summary.amt_bounty), currency_tourney_toglobal[tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon +
tourney_summary.amt_bounty, tourney_summary.currency]])

to

Code: Select all

sum(if[tourney_summary.val_curr_conv != 0, tourney_summary.val_curr_conv * (tourney_summary.amt_fee + tourney_summary.amt_fee * tourney_results.cnt_rebuy), currency_tourney_toglobal[tourney_summary.amt_fee + tourney_summary.amt_fee * tourney_results.cnt_rebuy, tourney_summary.currency]])

which seems to work.

Is that okay or did I miss something?

[ElHive]

Ok, apparently one can only edit a post for like 20 minutes :shock:

I didn't factor in the addons so the final edit of the two columns looks like this:

amt_fee_ttl:

Code: Select all

sum(tourney_summary.amt_fee + tourney_summary.amt_fee * tourney_results.cnt_rebuy + tourney_summary.amt_fee * tourney_results.cnt_addon)

amt_fee_ttl_curr_conv:

Code: Select all

sum(if[tourney_summary.val_curr_conv != 0, tourney_summary.val_curr_conv * (tourney_summary.amt_fee + tourney_summary.amt_fee * tourney_results.cnt_rebuy + tourney_summary.amt_fee * tourney_results.cnt_addon), currency_tourney_toglobal[tourney_summary.amt_fee + tourney_summary.amt_fee * tourney_results.cnt_rebuy + tourney_summary.amt_fee * tourney_results.cnt_addon, tourney_summary.currency]])

The stats look like this then:

My Currency Fee Total: https://imgur.com/qwICz4L

Game Currency Fee Total: https://imgur.com/BDQ7NBT