2 Replies Latest reply on May 22, 2016 11:22 AM by howardcallender

    FilterValues Question

    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!