"Hands in K" and format expression question

[andy2001]

Heres my atempt it validates, but shows up as "Expresion invalid operation specified in expression" when I try to use it.

[WhiteRider]

It looks like you have your IF statements a little messed up.
If you want to nest IFs you need to do it like this:
if( x, 'this', if( y, 'that', if( ... ) ) )

My version is attached, although it doesn't have the "111" part that you have.

[andy2001]

Ok that seems to work. The only issue I can see with it is you can't get it show the sample size.

[kraada]

If you change the value expression to exactly:

( cnt_vpip / (cnt_hands - cnt_walks)) * 100

It should show that properly. The stats need to be in exactly ( X / Y) * 100 format for the times/opportunities property to work.

[andy2001]

It seems to already contain "(cnt_vpip / (cnt_hands - cnt_walks)) * 100"

Code: Select all

if (( (cnt_vpip / (cnt_hands - cnt_walks)) * 100) > 99.5, '99', (format( '{1}{2}', if  (((cnt_vpip / (cnt_hands - cnt_walks)) * 100) < 9.5, '0', ''), format_number( ((cnt_vpip / (cnt_hands - cnt_walks)) * 100), 0, false, false) ) ))

[kraada]

Not the format expression the Value Expression in the top box. You have it as ( 100*(cnt_vpip / (cnt_hands-cnt_walks))) in the screenshot above.

[andy2001]

This is my RFI stat apart from no sample size, it will not filter by position when I set it in the HUD.

[kraada]

That's because of your value expression - you probably want that to be:

(cnt_p_raise_first_in / cnt_p_open_opp) * 100

That way the stat has the right value you just see your specialty display that you prefer.

[andy2001]

But if do that I won't have the format capping it at 99, so I may as well use the defualt stat.

[kraada]

The format expression will still control what you actually see on the table, that won't change.