Duplicate/create Column - not valid SQL

[povva]

Hi, sorry if it's dumb questions, I've searched the topics, but didn't find an answer.

I have custom column for exampl.:

cnt_vpip_less_than_8bb

Expresion:
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) < 8 AND tourney_hand_player_statistics.flg_vpip, 1, 0])

If I want to duplicate it and make for exampl.-
cnt_vpip_less_than_5bb
sum(if[(tourney_hand_summary.amt_p_effective_stack / tourney_blinds.amt_bb) < 5 AND tourney_hand_player_statistics.flg_vpip, 1, 0])

It shows me "not valid sql". What I'm doing wrong?

[kraada]

The first isn't valid either - amt_p_effective_stack is in tourney_hand_player_statistics, not tourney_summary - you probably got it there from importing an old stat from PT3 where it was in that location.

Changing it to tourney_hand_player_statistics.amt_p_effective_stack will fix your problems (and get that other stat to work properly as well).