Invalid type in operator ==

[cwoo]

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

[CharlieS · Accepted solution]

Is the [Period] field a string? If not, remove the quotes around the values and give that a try.

[MarqueeCrew · Accepted solution]

@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

[MarqueeCrew]

@CharlieS ,

Great minds think alike.  Very loose definition of great.

Cheers,

Mark

[cwoo]

That did the trick. Thanks!

The [Period] field was an integer.

Thanks,

Christine