4 Replies Latest reply: Aug 3, 2010 8:24 AM by Goran Korsgren RSS

    Set analysis help needed - Word that starts with or include

      Hi guys

      I have an item master. Each item has an ITEMCODE. I want to do an EXPRESSION in a STRAIGHT TABLE as the following:

      =sum(COST) to get a VALUATION of my stock. The problem is that I only want the valuation of items that has a certain ITEMCODE.

      I only want the value of items that starts with a "F" or "FZA". I only know how to do a set analysis on a whole ITEMCODE (see below).

      Obviously would this not help as I will have to list every ITEMCODE I want. Is there a way that I can do a set analysis on an ITEMCODE that starts with "F" or "FZA"?

       

      sum({<ItemCode={F10024000'}>} Cost)