Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors