if statement in app

[Tommmy]

Hi experts:

I would like to restrict a dimension by the following statement in the app but syntax is incorrect. Any ideas?

=If(Len(Trim(Type))>0,V_TYPE,v_type)={'I','J'},[Reference], [Invoice]

Thank you.

[Bill_Britt]

Hi,

The old saying keep it simple. Create a text object and work with each section one at a time. 

[BrunPierre]

Please write the logic literally.

[Or · Accepted solution]

You can't use {'I','J'} in an if() statement. You're mixing regular syntax and set analysis syntax here.

You can use Match() instead, or check against each value individually with an IF(A OR B), or write two separate If() statements.

Additionally, you seem to have closed the if() statement before you even get to the I/J part, so it's not actually clear what you're comparing / trying to achieve. Perhaps there's an external if() statement that's missing?