I have numeric values (with decimals) that start in the input as vstrings. In the select tool I change it to a double because it is used in a formula later in the workflow. For some reason when the value comes out of the select tool it is suddenly a whole number completely different from the original value. Example: the billing amount starts out as 1311.53 but the output after the select tool the value = 1. Why is this happening? I've never seen this before. I have provided a sample of the workflow, the sample data and the outputs before and after the select tool. Can someone please explain why this happens?
Thank you in advance!
Cherie