Custom - Highest in the table and show only if higher than x

[dNver]

Hi,

I built a tournament player stat, let's call it "B", it's formula is = 1 / (live_amt_stack / 20000)

I want to know if there is a way to create another custom stat, let's call it "M", which shows the highest value for "B" from everyone in the table. Let's say the "B"s of everyone at the table are 1, 0.5, 1,5 and 3. I want this new custom stat, "M" to show 3.

If this is possible, I want to know if there is a chance that "M" only appears in the hud if it's higher than a specific value, so if all the "B"s in the table are lower than this specific value, "M" won't show in the hud.

Sorry for my English.

[Flag_Hippo]

Unfortunately I don't know of a method to compare and test those values between players.

[dNver]

Unfortunately I don't know of a method to compare and test those values between players.

Okay

A total different question, is there any way to show the minimum stack at the table but only if it's lower than X amount?

[Flag_Hippo]

That's beyond my own SQL knowledge I'm afraid so I can't comment on whether it's feasible or not to create such a statistic.

[WhiteRider]

I think that should be possible.

If you make a copy of the stat "Live Min Stack BB" (*) you can change the format type from Number to Expression.
(*) I'm assuming you want this in BBs since it's for tournaments. If not, do the same sort of thing for "Live Min Stack".

You can then add an IF into the format expression.
For example:

format( '{1}', if((live_table_min_stack / live_amt_bb) < 10, format_number(, (live_table_min_stack / live_amt_bb),0), 2, true, false), "" )

That expression will display the min stack if it is less than 10 BBs or an empty string ("" = blank) otherwise.
You can change the number of BBs and the alternative "text" to be displayed as you prefer.