Adding an if condition to a sum

[lkastel]

For example, say I want to make a column that holds the number of times the player has raised the flop in hands with antes.

I create a duplicate of cnt_f_raise, and change the expression from this:

sum(tourney_holdem_hand_player_statistics.cnt_f_raise)

to this

sum(if[tourney_holdem_hand_player_detail.amt_ante > 0, tourney_holdem_hand_player_statistics.cnt_f_raise, 0])

Will that give the right result?

[WhiteRider]

Exactly right - good work!