Thank you

Can you give an expample? I tried to duplicate the values from the Won% stat from player to hand to statistic but then when i added this column in a hand report i do get a sql error Even when this is the only stat in this report. Reason: Fatal Error (ERROR: column "tourney_hand_summary.id_hand&...

But if i create a hand report i don't have the %won stat available .

WhiteRider wrote:To add the Hand # stat to your report type "hand" into the search field then double click the stat in the list above to add it.'[/url]

I was looking for this also. When i create a Player report and then select player and create the report the stat hand # is not available to choose.

That's because you are probably still in a tournament Or its a satellite where you won a seat and folded the last hand.

Anyway, getting back to the original question, I think this expression will work. exists ( select 1 from ( select ths.id_tourney, max(ths.date_played) over (partition by ths.id_tourney) last_played from tourney_hand_summary ths) as ths_hands where tourney_hand_summary.date_played = ths_hands.last_p...

No this report is the same as i use this expression (tourney_hand_player_statistics.amt_before = tourney_hand_player_statistics.amt_bet_ttl AND tourney_hand_player_statistics.flg_won_hand = false) I get 17 tourneys and 25 hands. This is because i play a lot of rebuy sattelites and rebuys is seen as ...

tourney_hand_summary.hand_no i created a copy of this one i tried to ad a Max value. Without max value it shows rows .

Hi Ronin, tnx for thinking with me to find a solotion but the stat Id_final_hand is not the last hand in a tournament but the hand at the river and that id is not unique. I stead i use the stat Hand # this gives me the tournament hand no from the pokersite See attachment Naamloos.png As you can see ...

You are right. i know i need a MAX function because i have this in microsoft access but in a pokertracker report is not that simple :) This is what i tried. I duplicated the column hand_no stat as Highest_hand_ID and changed the summery type in the expression to Max. I also created a new duplicated ...