The above formula is to prevent us from duplicating an invoice number, the first half of the expression is getting the list of all current invoices that are not being moved out of the system via Denied/Removed status. The second portion is bringing in the set of all paid invoices based on vendor ID. My test on expression assistant is telling me that it should be invalid but it is not. I don’t see anything inherently wrong with the formula but it seems to be happening elsewhere as well so I’m guessing there is?
Austin_Lambeth:
My test on expression assistant is telling me that it should be invalid but it is not.
What does this mean?
Austin_Lambeth:
I don’t see anything inherently wrong with the formula but it seems to be happening elsewhere
What does this mean?
The test in expression assistant is return False for my valid if formula on the specific row I have found where it in not setting the value to invalid
It is not isolated to this row, I forgot that I didn’t mention any specifics so that statement doesn’t make much sense.
Consider breaking the expression into smaller parts and testing them individually to make sure each part gives the expected result.
AND both list individually?
I’d start with the first SELECT() only, noting else. Does it return the expected list?
So far the only thing I’ve learned about the IN() statement is just try not to use it. Breaks in Slice Filters, breaks in security filters, and apparently can break in valid if statements.
Wrap it with:
AND(
TRUE,
IN(.....)
)