General Discussions

Discuss any topics that are not product-specific here.

Formula Not Working

codyfink
7 - Meteor

I am used to Excel and working with IFS statements well need to say the least Alterxy is giving me issues trying to figure this out. When trying to finish the last ELSE IF Statement it will not work. Keeps popping up with this issue.... Need Expertise please!!!

 

codyfink_0-1685718570383.png

 

5 REPLIES 5
binuacs
20 - Arcturus

@codyfink Make sure the data type of the field Percent is numeric 

codyfink
7 - Meteor

This what keeps popping up... Guess I am not sure 

 

codyfink_0-1685719405761.png

 

codyfink
7 - Meteor

This is the data going into my formula.

 

codyfink_0-1685719465902.png

 

binuacs
20 - Arcturus

@codyfink In the select tool change the data type of percent field from string to double and run the workflow 

codyfink
7 - Meteor

It worked thank you!!!!

Labels