For example i got Country code as string (example: AF AG AR)
Also i got Cost column
I want for to apply a condition: if(Country code == AF, Cost*2)
The issue is that it applies Cost*2 for all Cost column. I want it only to row where country code is AF
Calculate individual values doesnt work for it.
How can i do this?
Thank you for writing to our forum.
Please kindly note that only number comparison is currently supported in calculated values. Our team suggests changing the
Country code column to a numeric one. For example, replace
2. This would allow using the newly created column in conditions.
Please let us know if any further questions occur.
Thank you! It worked.
How can I convert string value to Int in calculated values?
Thank you for your swift response.
There isn’t any built-in functionality that would convert your string fields to numbers for calculated value formulas.
As a workaround, you could top up your data set with a separate field containing the numbers you can use for calculated value formulas.
We hope this helps.