This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi
I am getting an Invalid type in operator == error on a tool and I don't know why. I did use the ToNumber() formula to see if that is causing the issue but I still see the issue.
Can someone help resolve it?
Thanks,
Christine
Solved! Go to Solution.
Is the [Period] field a string? If not, remove the quotes around the values and give that a try.
@cwoo ,
Please check to see if [Period] is a string data type. If it isn't, then remove the quotes from 1,2,3,4.
Also, your ELSE statement is putting "" into a DOUBLE field. That should probably be:
ELSE NULL()
Cheers,
Mark
Great minds think alike. Very loose definition of great.
Cheers,
Mark
That did the trick. Thanks!
The [Period] field was an integer.
Thanks,
Christine