Page 1 of 1

amount lost stat

PostPosted: Tue Apr 13, 2010 4:09 pm
by vinny
Hi

i downloaded the custom report of " My Big Loss Hands from pooriver . bud it shows the My big win hands.

Howe do i make a statistic for my amount lost ?

When i do it, the message comes "the statement is not valid SQL"
name

amt_bb_lost

expression

holdem_hand_player_statistics.amt_lost / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult)


name

amt_lost

expression

holdem_hand_player_statistics.amt_lost

thanks vinny
version beta 30.10

Re: amount lost stat

PostPosted: Tue Apr 13, 2010 4:34 pm
by kraada
The Amount Won stat is your net win/loss - if you have lost money, Amount Won will be negative.

Re: amount lost stat

PostPosted: Tue Apr 13, 2010 5:28 pm
by vinny
I have changed "amt_bb_won >= 15 to amt_bb_won <= -15 in the report
and now it shows the hands i lose the most on.

Is there a faq were all the different words are listed that we can use fore building custom stats?


Thanks kraada

Re: amount lost stat

PostPosted: Tue Apr 13, 2010 6:06 pm
by kraada
For the filters you mean? You can use any column that you would like; clicking the blue Insert link will show you all of the available options.

Re: amount lost stat

PostPosted: Wed Apr 14, 2010 3:51 am
by vinny
ok

thanks vinny