Thanks again Mr Rider for helping me out, i really wish i could show my gratitude in some other way than just typing "thanks" Im well aware that helping me is time consuming on your part
I followed your directions but i seem to have a slight problem. First let me explain my theory behind using this statistic to help my game so that we can be on the same page.
The amount of money Lost (its impossible to win in Big Blind position at a 6 max table in the long run) is irrelevant unless it is summed up in Big Bets/100 hands. I have pooled over 20,000 players with over 15,000,000 milion combined hands. I then Found that the average amount of money LOST
while playing 6max table, big blind position, heads up is 23 Big bets per 100 hands. If this number is lower then the player is good at playing his blinds heads up (assuming a large hand count), if the number is higher then the player is not good(and i can and should find a way to take advantage)
i used the following code in the expression
sum( if[ holdem_hand_player_statistics.position=8 AND holdem_hand_summary.cnt_players > 3 AND holdem_hand_summary.cnt_players_f=2 AND holdem_hand_player_statistics.flg_f_saw, holdem_hand_player_statistics.amt_won / (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult) , 0 ] )
Unfortunatly the numbers this code gives back do not make much sense, did i screw up some where when substituting the code for BB/100 hands? When i manually type in the filters, the numbers do not match with the numbers this stat gives
Is it also possible that the equation does not take into consideration that the player was forced to put money in the pot PREflop and thus does not count the bigblind as the player's money?