In Fusion 2.0, how do I convert a number to text? | Community
Skip to main content
Level 2
Nov 16, 2021 8:44 PM UTC
Solved

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

No text available
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

7 replies

Doug_Den_Hoed__AtAppStore
New Participant
Nov 17, 2021 8:30 PM UTC

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

Translate
JohnGr3Author
Level 2
Nov 17, 2021 10:25 PM UTC

Thanks, Doug. That was going to be my Plan B.

Translate
skyehansen
Level 4
Nov 17, 2021 6:08 PM UTC

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%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-data-expressions.html&_LANG=enus ) -- 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.

Translate
JohnGr3Author
Level 2
Nov 17, 2021 8:14 PM UTC

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}})"

Translate
skyehansen
Level 4
Nov 17, 2021 8:20 PM UTC

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

Translate