By pot size custom stats

[DOMIATED89]

I'm also doing one for the BB Pot Size, but get the error message "not valid SQL:

Code: Select all

if[ amt_pot / amt_bb < 10, 1, if[ amt_pot / amt_bb < 20, 2, if[ amt_pot / amt_bb < 30, 3, if[ amt_pot / amt_bb < 40, 4, if[ amt_pot / amt_bb < 50, 5, if[ amt_pot / amt_bb < 75, 6, if[ amt_pot / amt_bb < 100, 7, if[ amt_pot / amt_bb < 125, 8, if[ amt_pot / amt_bb < 150, 9, if[ amt_pot / amt_bb < 200, 10, if[ amt_pot / amt_bb < 300, 11, if[ amt_pot / amt_bb < 400, 12, 13]]]]]]]]]]]]

[Flag_Hippo]

Thanks, but I now get a different error "This column is not cacheable".

If the 'Cache' checkbox is enabled when trying to save the column that message will appear and the cache option is turned off. This type of column is not cacheable so the 'Cache' checkbox needs to be unchecked:

Guide: Database Caching (When a Column Cannot be Cached)

I'm also doing one for the BB Pot Size, but get the error message "not valid SQL:

Code: Select all

if[ amt_pot / amt_bb < 10, 1, if[ amt_pot / amt_bb < 20, 2, if[ amt_pot / amt_bb < 30, 3, if[ amt_pot / amt_bb < 40, 4, if[ amt_pot / amt_bb < 50, 5, if[ amt_pot / amt_bb < 75, 6, if[ amt_pot / amt_bb < 100, 7, if[ amt_pot / amt_bb < 125, 8, if[ amt_pot / amt_bb < 150, 9, if[ amt_pot / amt_bb < 200, 10, if[ amt_pot / amt_bb < 300, 11, if[ amt_pot / amt_bb < 400, 12, 13]]]]]]]]]]]]

You should use cash_hand_summary.amt_pot instead of amt_pot and cash_limit.amt_bb instead of amt_bb:

Code: Select all

if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 10, 1, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 20, 2, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 30, 3, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 40, 4, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 50, 5, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 75, 6, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 100, 7, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 125, 8, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 150, 9, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 200, 10, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 300, 11, if[ cash_hand_summary.amt_pot / cash_limit.amt_bb < 400, 12, 13]]]]]]]]]]]]

[DOMIATED89]

Thanks for this I have the "by street" one working. I will look at the "by pot-size" one when I have more time to look at it.