Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Multi-Field Formula Tool Integer Warning

lwolfie
11 - Bolide

We recently converted to 2023.1.  I have a workflow where I'm converting several text fields to numbers.  Prior to the upgrade, we didn't receive any warnings.  However, now I receive a warning stating that the formula resulted in a integer but the field is numeric.   It doesn't look like any data is lost, but it does cause individuals running the workflow to question if the data is correct.  

 

Has anyone seen this happen?  

 

Data Before the tool

Field1                 Field 2             Field 3

3,000,000.00    3,003,307.51    0.00

 

I'm using a simple 

TONUMBER(REPLACE([_CurrentField_], ",", ""))

 

I'm creating a new field and I've tried changing to Double and Fixed Decimal and get the same warnings.

2 REPLIES 2
cjaneczko
13 - Pulsar

I am on 2023.2 and do not seem to be getting any error.

 

 

image.pngimage.pngimage.png

lwolfie
11 - Bolide

The culprit appears to have been the AMP engine.  I had to select AMP and the warnings went away.

Labels