How to get rid of $ sign

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

How to get rid of $ sign

Postby recooke » Mon Jan 11, 2010 11:23 pm

I am trying to get rid of the $ sign on a report I created. I customized the "Flop Bet" statistic as follows
amt_bet_f / lookup_limit_bb( id_limit ) *2
This gives me the amount bet on the flop in terms of how many big blind units were bet rather than how many dollars were bet.
Only it still shows up on the report preceded by the $ sign. How do I get rid of the $ sign?
Thanks.
recooke
 
Posts: 32
Joined: Sun Nov 15, 2009 11:46 am

Re: How to get rid of $ sign

Postby WhiteRider » Tue Jan 12, 2010 5:29 am

Have a look at the Format tab of your new stat - it probably includes format_money.
If you change that to:
/%.2f
..it will format the value to 2 decimal places.
Or you could use:
format_number( column_name, 2, true, true )
..if you want the values coloured red and green.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests