Please send specific information detailing this to us in a Support Ticket with relevant screenshots of your PokerTracker 4 report windows and your support bundle where a technician can give you further assistance:
I've never seen this software mentioned before but try running all your software (PokerTracker 4, PokerStars and any other additional applications) as administrator - see this guide.
The second code you gave me is not valid. You also need to include a value (or range of values) for the amount of big blinds you want as per the final example (which is for an adjusted bb amount greater than 50). Anyway I think what I need is the third one but doesn't work properly. Let me explain ...
That's a known issue as far as I am aware in a specific scenario. If you open a Support Ticket quoting reference #6606 we can follow up on this with you.
That will need an expression filter: Cash cash_hand_player_statistics.amt_expected_won / cash_limit.amt_bb Tournaments tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb Bear in mind that in hands with no all-in adjustment the adjusted result will be the same as the actual resul...
Both queries can use the database cache so there shouldn't be any noticeable difference. Also the two expressions you've given don't do the same thing since lookup_actions_f.action = 'X' is specific to a player wheareas tourney_hand_summary.amt_pot_t = tourney_hand_summary.amt_pot_f is specific to t...
You can import that and then convert it to a tournament statistic by selecting the cash version in 'Configure -> Statistics' and then on the details tab choosing 'Options -> Convert'.
That statistic is for tournaments so if you are trying to add it to a cash game HUD you will not see it. You can convert this to a cash statistic by selecting the stat in 'Configure -> Statistics' and then on the details tab choosing 'Options -> Convert'.