"Hands in K" and format expression question

[StevenM]

mager -

Were you aware that we will be adding "hands in k" in an upcoming beta release? If your willing to hang tight, this will be added pretty soon.

[WhiteRider]

You can remove all of your custom stats by closing PT4 down and then moving/renaming the "StatDefinitionsCustomized.pt4" file in the Data folder which you can find via the menu File > Open User Data Folder. This will clear all of your custom stats, so make sure you have exported any stats you want to re-import before you do that.

[mager]

Hmmm I can hang tight with the "hands in K" stat but truthfully, I would like to know why it is not working.
I'm kinda in a learning mode right now with postgreSQL, so it will be nice to understand why it is not working.


More critical to me is the other formatting expression that does not work to me:

Code: Select all

if ( (this) > 99.5, '99', (format( '{1}{2}', if ( (this) < 9.5, ' ', ''), format_number( (this), 0, false, false) ) ))

It is valid but it shows the full format expression on the table instead of the stat. Why is that and how to fix it?

[WhiteRider]

That format expression works fine for me. Please export your stat and attach it to a Support Ticket so that we can check it out. Attach your Hands K stat too and we'll see what's wrong with that too.

[mager]

Of course I made another attempt and now it worked
Hands in K still not working so I opened support ticket.

Anyway, the format expression did not cut the number from 100 to 99 when only putting the expression under format expression.
Should I also put it in value expression(this was the solution on the last thread)? If so, I can not use "this" and have to copy the exact value expression right? And should I put the whole expression or just part of it?
Also, should I put it in brackets after the value expression or a simple "," will be good enough?

Lastly, do I want to keep the "/%.2f" or is it unnecessary? And if I want to add to the expression that if there are no opportunity, use certain text - how do I do it(I know I can do it under "Reporting Options" but I want it to match to the specific color I use, and I use multiple colors)?

Thanks.

[WhiteRider]

It works fine for me:

BTW, I did use "this" to set this up, but it has been expanded as I closed and re-opened the window.

You cannot use /%.2f if you're using the above format expression - they are different ways of formatting and you need to use one or the other.
If you're still having problems getting this working please attach your stat to a ticket, if you didn't already.

To display different text when there are no opportunities use another IF statement, like:

if( (cnt_hands - cnt_walks) = 0, 'NA', normal formatting expression )

[mager]

It works fine for me:

2012-03-03 09h56_52.png

BTW, I did use "this" to set this up, but it has been expanded as I closed and re-opened the window.

You cannot use /%.2f if you're using the above format expression - they are different ways of formatting and you need to use one or the other.
If you're still having problems getting this working please attach your stat to a ticket, if you didn't already.

To display different text when there are no opportunities use another IF statement, like:

if( (cnt_hands - cnt_walks) = 0, 'NA', normal formatting expression )

1. On reports it is working for me as well. But on the table it is not:


Why and what should I do?

2. What does "normal formatting expression" mean in this expression? Can you give an example of how it would look like for RFI?
if( (cnt_p_open_opp) = 0, 'NA', normal formatting expression ) ? (I add this to every stat I use in the HUD, and then under reporting options I set "no opportunity text" to nothing?)
Also, should I put it in brackets after the other part of the expression or a simple "," will be enough?

Thanks.

[WhiteRider]

1. OK, I'm seeing the same thing in the HUD. It looks like the HUD is displaying the Value Expression rather than the Format Expression.
I will discuss this with the development team.

2. This will not work when the Value Expression is a normal (a / b) * 100 expression - in that case the default N/A text will always be used.
However, if you change the Value Expression to a different form, for example:
100 * (a / b)
..then the HUD will not know the structure, and will therefore not display N/A, meaning that your Format Expression will be displayed instead.
The "normal formatting expression" can be whatever you want it to be, such as a format_number expression like this:

if( cnt_p_open_opp = 0, '---', format_number((cnt_p_raise_first_in / cnt_p_open_opp ) * 100, 2, false, false) )

This displays --- if there are no opportunities, or the number if there are (and works fine - I just tested it in the HUD).

[mager]

1. Ahh OK. I hope you will fix this issue as soon as possible.

2. So for RFI for example, I can use:

Code: Select all

if ( (this) > 99.5, '99', (format( '{1}{2}', if ( (this) < 9.5, ' ', ''), format_number( (this), 0, false, false) ) )), if( cnt_p_open_opp = 0, '--', format_number((this), 0, false, false) )

or should it be:

Code: Select all

(if ( (this) > 99.5, '99', (format( '{1}{2}', if ( (this) < 9.5, ' ', ''), format_number( (this), 0, false, false) ) ))) OR (if( cnt_p_open_opp = 0, '--')  format_number((this), 0, false, false) ))

And after you will fix the format expression issue - it will do everything that I wanted(fixed size 'boxes' based on two digit number, in addition to showing "--" when there are no opportunities)?

Thanks.

[WhiteRider]

The outer bracket is not needed - either is fine.
Yes, that should display what you want, and will work now if you rearrange your Value Expression too.