Formula error

[AhanaR]

Hi team,

could someone help me correct the error in this formula? I'm trying to convert final currency values into USD using plan rates .

I tried converting all values in decimal fixed as it was giving me errors related to string values.

Data set 1:

Final Price Currency	Final Price
USD	0
INR	14000
IDR	67000
AUD	77122

Dataset 2:

Currency code	Plan Rates	Market Convention
IDR	15585	I
AUD	0.6696	D
INR	82.821	I

IF [Final Price Currency]="USD"
THEN [Final Price]
ELSEIF [Market Convention]="I"
THEN [Final Price]/[Plan rates]
Else [Final Price]*[Plan rates]
ENDif

[FinnCharlton]

Hi @AhanaR , this error is due to a mismatch of data types - one of your numeric fields is set as a string. Put a select tool before the formula tool and ensure your numeric fields are a numeric data type, such as Double. Hope this helps!

[binuacs]

@AhanaR as @FinnCharlton mentioned the error might be because of the datatype issue, you can also change the datatype in the Join tool