Invalid type in operator !=.

[ShantanuDagar]

Hey all, 

I am getting the above error in one of my filter to validate data.

The validation is: ([Status]="Existent" AND [ABC %]>[EFG %] AND ([EFG %]!= 0 OR [EFG %]!= "" ))

Data type of EFG is double.

If status = Existent, ABC % should not be greater than EFG %

Have to identify the values which doesn't satisfy the above condition if status = Existent. Need those values out of T output anchor.

Also have to exclude those with EFG% values as 0 or blanks.

Major doubt is about the Error as in title. Every other validation on different columns is working perfectly.

[binuacs · Accepted solution]

@ShantanuDagar Can you update your formula like below and try again? 

([Status]="Existent" AND [ABC %]>[EFG %] AND ([EFG %]!= 0 OR !isEmpty([EFG %])))

[ShantanuDagar]

Works now, thanks for quick fix.

[ShantanuDagar]

@binuacs hey 

I am still getting records with 0 in EFG column. 

Is there any issue in validation?

0 values aren't excluded