(Fold / saw flop) * 100

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

(Fold / saw flop) * 100

Postby BoFo » Sat Nov 22, 2008 11:21 pm

Hi again!

I want to see how often he folds (flop, turn, river) after seing flop. Tried a lot, e.g.:

((cnt_f_fold + cnt_t_fold + cnt_r_fold) / cnt_f_saw) * 100

but got this: "expression: parameters on the left and right side of an operation must be compatible."

Which "operation"? +, /, or *? How come one cnt is not compatible to another?

I also tried a smaller one: (cnt_r_fold / cnt_f_saw) * 100, and it works! I just cant make the addition of all streets.

Help!
BoFo
 
Posts: 31
Joined: Thu Aug 14, 2008 10:46 am

Re: (Fold / saw flop) * 100

Postby Oakrdrzfan » Sat Nov 22, 2008 11:51 pm

BoFo wrote:Hi again!

I want to see how often he folds (flop, turn, river) after seing flop. Tried a lot, e.g.:

((cnt_f_fold + cnt_t_fold + cnt_r_fold) / cnt_f_saw) * 100

but got this: "expression: parameters on the left and right side of an operation must be compatible."

Which "operation"? +, /, or *? How come one cnt is not compatible to another?

I also tried a smaller one: (cnt_r_fold / cnt_f_saw) * 100, and it works! I just cant make the addition of all streets.

Help!


not for sure, but it looks like you need another parenthesis on the right hand side.
Oakrdrzfan
 
Posts: 303
Joined: Sat Jan 19, 2008 6:50 pm

Re: (Fold / saw flop) * 100

Postby WhiteRider » Sun Nov 23, 2008 5:30 am

Your expression:
((cnt_f_fold + cnt_t_fold + cnt_r_fold) / cnt_f_saw) * 100
..works fine for me.
Where are you using this - in the Value Expression field of the Statistics tab?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: (Fold / saw flop) * 100

Postby BoFo » Sun Nov 23, 2008 9:41 am

No, in the HUD
BoFo
 
Posts: 31
Joined: Thu Aug 14, 2008 10:46 am

Re: (Fold / saw flop) * 100

Postby BoFo » Sun Nov 23, 2008 9:55 am

Hej, it works. Seems a good nights sleep and a restart of the computer helped. Sorry for the inconvenience!
BoFo
 
Posts: 31
Joined: Thu Aug 14, 2008 10:46 am

Re: (Fold / saw flop) * 100

Postby shalder » Sun Nov 23, 2008 2:28 pm

When u edit a statistic, u often have to reboot the hud (or poker tracker) for it to take effect on the HUD.
If u had an error in the statistic before u edited it, the hud will continue to show errors until u restart
the program. At least that's been my experience.
shalder
 
Posts: 51
Joined: Sat May 31, 2008 9:16 pm

Re: (Fold / saw flop) * 100

Postby WhiteRider » Sun Nov 23, 2008 6:27 pm

That's right - you have to restart the auto import. I can't remember whether just restarting the HUD is enough..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 1 guest