PokerTracker

I don't understand why this doesn't work.

I have a custom "Players" column named val_last_aggressor_p defined as:

Code: Select all

RIGHT(cash_hand_summary.str_aggressors_p, 1)

Now I want to create another column named str_last_aggressor_p for formatting purposes.
The following expression is accepted as valid:

Code: Select all

val_p_last_aggressor = '0'

but if I change it to

Code: Select all

if[val_p_last_aggressor = '0', 'BTN', 'Other']

it gives me an invalid SQL error.

What gives?

I'm noticing now that my naming here is inconsistent, but the point stands. I've since renamed the columns to str_last_aggressor_p and str_last_aggressor_p_pos with the same issue.

lavis wrote:Now I want to create another column named str_last_aggressor_p for formatting purposes.
The following expression is accepted as valid:

Code: Select all

val_p_last_aggressor = '0'

but if I change it to

Code: Select all

if[val_p_last_aggressor = '0', 'BTN', 'Other']

it gives me an invalid SQL error.

Formatting isn't done within the column expression but there is a 'Format Type:' option on the 'Stats - Definition' tab where formatting can be specified. You will also need to use () brackets there and not [] brackets - see this guide for some formatting examples.

Thanks, yeah, I figured it out. But I'm still curious why this isn't valid? Can you not define a column using if statements involving other custom columns?

Unfortunately you can't reference columns within other columns.