Thursday, May 23, 2019

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

Solution:

 

 -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')

 

Solution:

 

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

No comments:

Post a Comment