Concatenate fields to get more than 4 decimal places result

[KAPITYAN]

I'm trying to concatenate a couple of number fields into a text field with a comma in between and it keeps rounding the numbers off at 4 digits past the decimal. How can I get it to show the full numbers?

Here is the formula that I am using:
CONVERT(VARCHAR, [@field:Num1Address]) + ',' + CONVERT(VARCHAR, [@field:Num2Address])

Both fields are Number Data type. 

Result should be:
23.901365999999,54.95645

But the result that I am getting is:
23.9014,54.9564

[NailDyanC]

Hi @KAPITYAN,

Can you please try to use this formula instead:

str( [@field:Num1Address], 10, 6) + ',' + str( [@field:Num2Address], 10, 6)

The formula above is another way to concatenate fields using other data types.

[TellMeWhy]

Just to add more information about NailDyanC's answer, you may refer to our HowTo Article about Function References. https://howto.caspio.com/function-reference/ , the Str() Function is under the Text Functions section