In Fusion 2.0, how do I convert a number to text? | Community
Skip to main content
Level 2
November 16, 2021
Solved

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

  • November 16, 2021
  • 2 replies
  • 1216 views
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.

2 replies

skyehansen
Community Advisor and Adobe Champion
November 17, 2021

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.

JohnGr3Author
Level 2
November 17, 2021

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

skyehansen
Community Advisor and Adobe Champion
November 17, 2021

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

Doug_Den_Hoed_AtAppStore
Community Advisor
Community Advisor
November 17, 2021

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

JohnGr3Author
Level 2
November 17, 2021

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