If and statement

[rubenacampos]

Hello,

I have the following if statement but I keep receiving an error message:

=if({<[Procurement Type]={"SERVICES","A&E","R&D","CONSTRUCTION"},[Procurement Action]-={"*MOD*"}>}[Procurement Type])

I want to show in a pie graph the procurement types for Services, A&E, R&D, and Construction but exclude the procurement actions coded as a Mod type.  I am using a wild card b/c there are multiple types of Mods.

Thank you in advance!

[Vegar · Accepted solution]

Try changing your expression to this

=if(match([Procurement Type],'SERVICES','A&E','R&D','CONSTRUCTION') and wildmatch([Procurement Action],'*MOD*'),[Procurement Type])

[rubenacampos]

Thank you, it worked!