VPIP 3 way

[iatracker]

Hi,
i know its possible with option profile to filter by N players but i need to
make a VPIP 3 way without that .
Reason is i want to display some 3way stat and 2 way stat in HU for example .

Is it possible to modify actual VPIP to filter result for 3 players dealt ?
Something like
if 3 players dealt (
(cnt_vpip / (cnt_hands - cnt_walks)) * 100
)

Really need help / example of how to do VPIP 3 ways please

[iatracker]

my not wroking try was to duplicate the cnt_vpip column in cnt_vpip_3H and add the condition of cnt_players (the column is in the same table tourney_hand_player_statistics) .
Then duplicate the vpip stat with same idea .

new column cnt_vpip_3H

sum(if[tourney_hand_player_statistics.flg_vpip
and tourney_hand_player_statistics.cnt_players = 3
, 1, 0])

Doesn't work , is the cnt_players is the N players dealt or N players didn't fold ?

[Flag_Hippo]

cnt_players is the number of players dealt in to the hand so that's fine. How exactly is it not working? If the values are not correct have you created custom columns to count 3 handed play for cnt_hands & cnt_walks? Have you rebuilt your custom database cache?

[iatracker]

forgot to add the cnt players conditions for cnt_walks column , it works now .
thanks