Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

In Fusion 2.0, how do I convert a number to text?

Avatar

Level 2
 
1 Accepted Solution

Avatar

Correct answer by
Community Advisor
7 Replies

Avatar

Community Advisor

is it the same as it is for a calculation in workfront? (https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FRe... ) -- as in, can you do anything with this? I checked the functions in fusion and couldn't find anything there. You might submit a ticket and see if that was an oversight on workfront's part.

Avatar

Level 2

If if is, it's not obvious. I tried (string({{3.NewItemID}}) but that didn't use it as a function, it just set the variable to the literal "string({{3.NewItemID}})"

Avatar

Community Advisor

you might submit a ticket then. Seems weird that they would have a formatNumber but no formatString function.

Avatar

Correct answer by
Community Advisor

Avatar

Level 10

Hi John,

Untested, but one common approach is to "coerce" the data type by concatenating it with an empty string (e.g. CONCAT(myNumber,""))

Regards,

Doug