Thursday, May 23, 2019

Item Saved Search Formula to Display Static Value when Item Name Contains Specific Word



 -If {itemid} contains the word "Kritter" the value would be 0. Otherwise, the value would be 1.


 -Item Name = Kritter Blue (This should appear on the Saved Search)

 -Item Name = Kritter (Formula - Case When {itemid} = 'Kritter' Then 0 Else 1 end will only capture this item and  not items that contain the word 'Kritter')




Formula (Numeric) = Case When {itemid} like '%Kritter%' Then 0 Else 1 end

No comments:

Post a Comment