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

    FilterValues Question




      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!