AnsweredAssumed Answered

FilterValues Question

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



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!