AnsweredAssumed Answered

FilterValues Question

Question asked by howardcallender on May 22, 2016
Latest reply on May 22, 2016 by howardcallender

Hi,

 

I have a field in my table called ProductDescription

I would like to filter some words to make a category

 

ProductDescription (text field)Category (What I would Like) (calculation)
Golden SpoonGolden
Spoon SilverSilver
Golden PlatesGolden
Silver PlatesSilver
Cups GoldenGolden
Wine Glass GoldenGolden

 

I have tried this and it doesn't work

 

Case (

FilterValues (ProductDescription; "Golden" ="Golden"); "Golden";

FilterValues (ProductDescription; "Silver" ="Silver"); "Silver";

"" )

 

Thanks for all your help!

Outcomes