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

7 則回覆
1264 次檢視
翻譯全部

No text available

Workfront

此主題已關閉回覆。

John, I found it! https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FWorkfront_Fusion%2FFunctions%2Fstring-functions.htm&_LANG=enus

(it's toString)

skyehansen

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.

翻譯

J

JohnGr3作者

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

翻譯

skyehansen

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

翻譯

Doug_Den_Hoed_AtAppStore

Community Advisor

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

翻譯

Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.

J

JohnGr3作者

Level 2

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

翻譯

註冊

社交登入

登入社群

社交登入