If Contains(Item Description, "AP&C") THEN 0 ELSE ORDER No END
Using 0 you can easily Filter out
Thank you for your response. But it is not going to work out in my case. I have added a sample workbook to explain the issue more clearly. I want to remove 34534 to 34546 from the first worksheet which currently is including all orders since OrderNo.'s are not unique.
Book1.twbx 21.0 KB
Thank you. It does solve the problem in the sample that I provided but it doesn't seem to work in the real data set.
This is the custom SQL query workaround I have used.
SELECT * FROM [dbo].[FMD15_18]
WHERE [OrderNo] NOT IN (SELECT [OrderNo]
FROM [dbo].[FMD15_18] WHERE [Item Description] Like '%AP&C%')
But it would be more helpful if there was a way to do this in calculated fields. If anybody knows how to do this, please let me know.
not sure I fully understand your goal but is this the output you expect for Orders that do not contain AP&C
if so the formulas are
set on filter shelf and set to true
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Book1 (5)_v10.2.twbx 41.9 KB