Tostring removing zeros

[Bobbins]

Morning All,

My data is 3 simple columns, a text field, a number field and a set decimal field

I want to create a 4th column where its the 3 columns joined together, IE:

"Smith 1.21 0.5000" 

However, when I use the following:

[Name] + " " + tostring([PPH]) + " " + ToString([Multipler])

It gives me this as the to string is deleting zeros:

How do I keep the zeros please?

Thank you

[DataNath · Accepted solution]

Hey @Bobbins, the second argument of the ToString() function is the numDec option, where you can define the number of decimal places in the output. Therefore, you could just set this to 4:

[Name] + " " + tostring([PPH]) + " " + ToString([Multiplier],4)

[Bobbins]

@DataNath , bah missed that nuance, thank you kindly!