Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Invalid type in subtraction Operator

Kinetic_analytics
11 - Bolide

Hello:

How may I fix this error?

 

invalid type.PNG

 

Thanks

 

3 REPLIES 3
binuacs
20 - Arcturus

@Kinetic_analytics 

 

IIF([Date]> [Yesterday],Null(),1+((DateTimeDiff([Yesterday],[Date],"days")* 5 -([StartWeekdays] -[EndWeekDays]) * 2)/7) + (IIF([EndWeekDays] ==6,-1,0)+IIF([StartWeekdays]==0,-1, 0)))

 

Spoiler
binuacs_0-1639093515821.png

 

Qiu
20 - Arcturus
20 - Arcturus

@Kinetic_analytics 
It seems that the column [EndWeeksDays] is a string type, which should be numeric type.

Can you kindly provide a data sample set?

Kinetic_analytics
11 - Bolide

Thank you.

Labels