what is this expression for?

[konig_acr]

I am trying to understand expressions but dont know if got it right?

Number of players dealt into the hand or number of players left in the hand? for example in this case 6 max mtt table?
Player position is 0 (where can i find the position for players?) is 0 the button?
player had the opportunity to open in 0 position
effective stack is 40bb+ or the stack of the player is 40bb+?
such player raise or limp preflop?

sum(if[tourney_hand_summary.cnt_players = 6
AND tourney_hand_player_statistics.position = 0
AND tourney_hand_player_statistics.flg_p_open_opp
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb >= 40)
AND (tourney_hand_player_statistics.flg_p_first_raise OR tourney_hand_player_statistics.flg_p_limp), 1, 0])

Is this statistic supposed to show me the times 0 position VPIP with 40bbs or more?

[Flag_Hippo]

Number of players dealt into the hand or number of players left in the hand? for example in this case 6 max mtt table?

It's the number of players dealt into the hand.

Player position is 0 (where can i find the position for players?) is 0 the button?

Yes. Position 1 is 1 seat off the button (CO), position 2 is 2 off the button and so on. Player 8 is always the BB and player 9 is always the SB.

player had the opportunity to open in 0 position

Yes

effective stack is 40bb+ or the stack of the player is 40bb+?

Of the player. The effective stack for each player is determined at their first action in the hand and it's the amount they could potentially lose in a pot as of their first action in the hand.

sum(if[tourney_hand_summary.cnt_players = 6
AND tourney_hand_player_statistics.position = 0
AND tourney_hand_player_statistics.flg_p_open_opp
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb >= 40)
AND (tourney_hand_player_statistics.flg_p_first_raise OR tourney_hand_player_statistics.flg_p_limp), 1, 0])

Is this statistic supposed to show me the times 0 position VPIP with 40bbs or more?

This column counts how often a player VPIP'd on the button when they had an effective stacks of 40bb+, an opportunity to steal/open the pot and 6 players were dealt into the hand.