Data type issues

Hello, I have a formula tool calculating some new columns. I have an error message as the data type is not compatible. (see screenshot attached).

From 'target price' down the Data type box is faded out so i cannot click into it and change the type.

I believe the 'discretionary discount' is the error as the penultimate formula it is output as V_WString data.

The formula:

Target price = double

Discretionary discount % = double (I checked at the join tool just before).

It all checks out to be double but is pulling the V_WString for that column and won't let me change it.

Can anyone please guide me? Any help will be really appreciated!!

data type issue.PNG

Datasets

Tips and Tricks

Connectors

Accepted answers

JosephSerpis

Hi @pangersandmash you need to use that function in your last formula Full Price GBP on the Discretionary discount field. The reason it's doesn't work in your screenshot is that conversion is happening at that formula and it returns to a string field in the formula below.

All comments

JosephSerpis

Hey @pangersandmash if you use the function ToNumber around the field Discretionary discount in your last formula it will convert the data type within that function and should remove the error. Note using that function will not permanently change the data type in the workflow.

pangersandmash

Hi @JosephSerpis Thank you for coming back to me on this. I forgot to mention i actually tried that. screen shot attached. still no luck 😞

data type issue 2.PNG

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703