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.
Solved! Go to Solution.
I am on 2023.2 and do not seem to be getting any error.
The culprit appears to have been the AMP engine. I had to select AMP and the warnings went away.