6 Replies Latest reply: May 26, 2014 3:20 PM by Wilfred van der Schaaf RSS

    Exclude multiple words form 'COUNT'

      I want to exclude two definitions of 'COUNT'. Probably not so complicated, but I do not get it done. One exclusion works fine, a second exclusion unfortunately not.

       

      What I would like to exclude: << choose from list >> and '...'

       

      The expression I use:

      Count ({$ <[Type or funtion] - = {"<< >> choose from list"}>} {$ <[Type of funtion] - = {"..."}>} [Type of funtion]) /

      Count (TOTAL <Corporatie> {$ <[Type of funtion] - = {"<< >> choose from list"}>} {$ <[Type of funtion] - = {"..."}>} [Type of funtion])

       

      Or: how to select only predefined textstrings in 'COUNT'