Visible Expression validation issue

Try this 

=iif(([AMProdOper.Descr]='Stage 2' and (Right([AMProdItem.InventoryID],4)))='-PGC', True, False)

Thanks Dermot, that validates but when I try to load the Production Ticket report I receive an error. I’m going to have to dig deeper into this...

Hi!

I believe that the InventoryID is a number and is not what you see in the screen. Try joining the InventoryItem table so that you can use the InventoryCD field, which is the text you need.

@swartzfeger agree with @miguel80 good spot InventoryID will be an int value

Thanks Miguel, you are right! I always forget about the ID vs CD. The report already had this join:

AMProdItem left InventoryItem, InventoryID = InventoryItem.InventoryID

I changed the expression to [InventoryItem.InventoryCD]

=iif(([AMProdOper.Descr]='Load roll of film for job' and (Right([InventoryItem.InventoryCD],1)))='C', True, False)

But it still throws this error in the stack trace

• Input string was not in a correct format.
• String was not recognized as a valid Boolean.
• Cannot convert the value 'C' to the type
• Cannot perform the '=' operation on System.Boolean and System.String.

You, sir, are a genius… thank you, Miguel!