1 2 Previous Next 15 Replies Latest reply on Nov 28, 2011 1:07 AM by AnastasiaPetukhova

    how to count each value in the value list

    AnastasiaPetukhova

      Title

      how to count each value in the value list

      Post

      Hi,

       

      I have a problem.

      I have a list of products (from a specific brand), each with a category (dropdown value list). The products also have status, such as "sold," "available," and others. Each product is unique and has a fixed quantity of 1.

      I need to count the number of unsold products in each category (I have 4 values in that dropdown) for specific brand.

      So it will look like this:

      Brand: Sony

      TVs (unsold): # - how to calculate?

      DVD players (unsold): # - how to calculate?

      and so on..

       

      Can you please help me with this? All the calculations I tried so far don't work. This is needed in the form layout, not as a report.

       

      Thanks!

       

       

        1 2 Previous Next