Rounding a number and concat text in a formula 2

[Craigmacs]

if {Profitability1_ttx.PROFITSEGMENT} = 'Silver' and {Profitability1_ttx.GOLD} > 0 then
cstr(Truncate(Profitability1_ttx.GOLD})) + " Lose"

I want 40 Lose
I'm getting 40.00 Lose

I must have the formula this way for many reasons.
I need to make the formula above work. Can anyone tell me whats wrong? Why wont the truncate work here.

 

[lbass]

Just add a "0" to the cstr function, indicating you want no decimals:

cstr(Truncate(Profitability1_ttx.GOLD}),0) + " Lose"

-LB

 

[Craigmacs]

Thanks Lbass