Skip to main content
JohnGr3
Level 2
November 16, 2021
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

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community Advisor
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.

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

Translate
skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community Advisor
November 17, 2021

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

Translate
Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity 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

Translate
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
    JohnGr3Author
    Level 2
    November 17, 2021

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

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...