Help - PS.it VPPs custom stat

[Serverbtest002]

I need custom stat in order to calculate VPP on ps.it
In the statistics tab, ander the columns I found amt_vpps
Expression:

sum(CAST( (if[cash_limit.flg_nlpl and cash_limit.amt_bb = .02 and cash_limit.limit_currency = 'USD' and cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 10, if[cash_limit.flg_nlpl and cash_limit.amt_bb = .05 and cash_limit.limit_currency = 'USD' and cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 8.5, if[cash_limit.flg_nlpl and cash_limit.amt_bb = .10 and cash_limit.limit_currency = 'USD' and cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 7, if[cash_limit.flg_nlpl and cash_limit.amt_bb = .02 and cash_limit.limit_currency = 'EUR' and cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 12, if[cash_limit.flg_nlpl and cash_limit.amt_bb = .05 and cash_limit.limit_currency = 'EUR' and cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 10, if[cash_limit.flg_nlpl and cash_limit.limit_currency = 'EUR' and cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 9, if[cash_limit.limit_currency = 'USD' and cash_hand_summary.id_site = 100 and cash_limit.limit_name LIKE '%max%' and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 5.5, if[cash_limit.limit_currency = 'EUR' and cash_hand_summary.id_site = 100 and cash_limit.limit_name LIKE '%max%' and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 7, if[cash_limit.limit_currency = 'GBP' and cash_hand_summary.id_site = 100 and cash_limit.limit_name LIKE '%max%' and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 8.8, if[cash_limit.limit_currency = 'USD' and cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 6, if[cash_limit.limit_currency = 'EUR' and cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 8, if[cash_limit.limit_currency = 'GBP' and cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 10.5,0]]]]]]]]]]]]) AS numeric(11,2) ))

on ps.it you earn 8 VPPs per Euro raked, how do I change the expression?
Ty

[kraada]

Does it vary by stakes at all?

[Serverbtest002]

no

[kraada]

Do they offer anything other than euro tables?

[Serverbtest002]

No, only Euro

[kraada]

Then this will do it:

sum(CAST( (if[cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 8, 0])

The normal PokerStars.com formula is quite a bit more complicated than it sounds like what PS.it does :)

[Serverbtest002]

I get an error, the statement is not valid SQL

Also I made an error, the VPPs per Euro are 8,5

[WhiteRider]

I'm not sure why we need the CAST in this case, so try this:

sum( if[cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 8.5, 0] )

If we do need the CAST then this:

sum( CAST( if[cash_hand_summary.id_site = 100 and cash_hand_player_statistics.amt_bet_ttl > 0, (cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake * 8.5, 0] AS numeric(11,2) ))

[Serverbtest002]

perfect ty a lot

Last question, now that I have modified the stat how do I export the new stat with the new column?

[kraada]

In the Configure -> Statistics window, highlight the stat and click Options -> Export. The necessary column will be exported as well.