Concatenating Currency Symbol with Double Type Values

[allwynbazil]

Team,

I need to concatenate the currency symbol with calculated values, which is a double data type. I used the conversion in the formula itself. However, it's not working and returned 0. Please help me to fix this issue.

Regards,

Alwin

[ShankerV]

Hi @allwynbazil 

Please convert the datatype from double to string.

This will help to resolve the issue.

Many thanks

Shanker V

[grazitti_sapna]

@allwynbazil , You cannot have any special character in numeric data type. You need to convert it to String to prefix $ sign in front of your number.

Example:

"$"+toString([Field1])

[ShankerV]

Hi @allwynbazil 

Please find the sample use case for your reference.

Input data:

Formula tool:

[Field2]+" "+tostring([Double])

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[allwynbazil]

Thanks, Shanker, for looking into the issue. Just converting to string will not help here, as I am going, to sum up, these values later. Instead of using multiple select tools am trying to achieve it in the formula itself.  Please share your ideas.

Regards,

Alwin

[allwynbazil]

Thanks,  grazitti_sapna, for looking into the issue. The currency symbol is based on the quote value and region. It is not just a  "$." 

Just converting to string will not help here, as I am going, to sum up, these values later. Instead of using multiple select tools am trying to achieve it in the formula itself.  Please share your ideas.

Regards,

Alwin

[Felipe_Ribeir0 · Accepted solution]

Hi @allwynbazil 

You will not be able to concatenate symbols with numbers and keep the field as double. The best way to proceed is to finish your calculations and just after that concatenate it and transform the field to text.

[grazitti_sapna]

@allwynbazil , Not sure if there is any way that you can have numeric data with special character. Instead you can sum up the data first and then prefix sign by changing it to string. But data with sign will be of string type and cannot be numeric, if yes then would be happy to see how this can be done.

[allwynbazil]

Yes, Felipe. I am currently doing the same.

Regards,

Alwin