Display values which is not selected with multiple Inputs

[#1]

Hello Everybody,

I am trying to get / display values which are not selected using multiple inputs (using inputbox).

Eg.

I have a table with product ID, sales and date. The user wants to see total sales of some specific product for particular period. I created the input box to paste multiple Products at a time (usually they select more that 1000). Some products from the inputbox will not be selected as they are not possible to select. So I want to display the products which are not selected in the listbox.

Now I am displaying only the count of selected products using GetPossibleCount(Product_ID)

Any help with this would be appreciated.

[swuehl]

You could try something like this in a text box:

=concat({<Product_ID = e(Product_ID) >} Product_ID,', ')

[CELAMBARASAN]

Hi,

     You can Subtract it like

     =Count({1} Distinct Product_ID) - GetPossibleCount(Product_ID)

or

    =Count({<Product_ID=E(Product_ID)>} Distinct Product_ID)

Celambarasan