Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Formula In-DB Tool

Highlighted
8 - Asteroid

I'm using a Formula In-DB tool to create a field.  I have the Type set to FixedDecimal but when the workflow runs the metadata shows this new field with size 36.0, so my values are coming out rounded to the nearest integer. 

 

I need the values to have at least 2 decimal places, so how can I adjust this to output the field as Size of 36.2 or 36.7?  Is there a CAST command I need to add to the formula?

 

Thank you.

Highlighted
Alteryx Certified Partner

@Adam_Dooley,

 

If the output is not coming out as you'd expect, yes, I'd suggest wrapping your current expression in a CAST/CONVERT function. You didn't specify what type of DB you're connecting to so you'll need to determine the correct function/syntax and the data type (and length if applicable) as required by your DB to perform this operation.

 

 

Hope this helps!

 

Jimmy

Highlighted
8 - Asteroid

Thank you jrgo!  It is an SAP HANA connection so it worked to use cast(...... as double).  Easier solution than I thought.

 

Thanks

Labels