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
Solved! Go to Solution.
Hi @allwynbazil
Please convert the datatype from double to string.
This will help to resolve the issue.
Many thanks
Shanker V
@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])
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
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
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
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.
@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.
Yes, Felipe. I am currently doing the same.
Regards,
Alwin