Stat for Effective Stacks (HUSNGs)

[kraada]

The min() version uses special values that only exist for live stats. The other columns are using values that are in the real database. In order for things to work in reports, you must use values like the latter.

One thing though that can make it a little easier, you can use:

tourney_hand_summary.amt_p_effective_stack BETWEEN X and Y

To catch all times where the stack was between those two values. One note though: Between in this contexts includes the endpoints. So BETWEEN 0 and 10 includes both 0 and 10.