We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Type Mismatching in Multi Field Formula

spirani
5 - Atom
‎06-18-2020 11:45 AM

I am trying to round decimals to 2 digits using multi-field formula but it shows an error saying String provided where a number is required.  The fields are set as double. 

 

 

Preview file
86 KB
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
BrandonB
Alteryx
Alteryx
‎06-18-2020 11:59 AM

Instead of using a multi field formula, could you instead use a select tool and change the data type to a Fixed Decimal with a length of 19.2?

Reply
0 Likes
Live Office Hours
Labels
Top Solution Authors
View All