Numeric value with decimals changes after Select tool to whole number
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @CherieACI
Issue was caused because commas were present in the number. Please add the highlighted formula tool to replace commas before conversion.
Workflow:
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much that worked!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @CherieACI
Cheers and have a nice day!
