Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Calculate using new field

Highlighted
7 - Meteor

skeen503979_0-1581627506207.png 

 

What am I doing wrong?  I just want to calculate margin using two existing fields (Rev_Unit and COGS_Unit) minus a newly created field (OPs Cost).  Do I need to add an additional Formula tool after this tool creates the new field?  I thought if I moved the margin calculation to the bottom it would have the new data to pull in.  The new field is just a number and I selected V_WString as the data type; is that correct?

 

Highlighted
Alteryx Certified Partner

Hi @skeen503979 ,

 

This is happening due to the way you build your clause. Since you are using double quotes in your numbers, it is identifying them as string, so you need only to remove the quotes and it will work.

Another thing non related with the error but that you need to do is to change your data type for double.

 

Best,

Fernando Vizcaino

7 - Meteor

Thank you, that worked.

 

skeen503979_0-1581629533601.png

 

Labels