2 Replies Latest reply: Aug 31, 2016 12:46 PM by KHOA NGUYEN RSS

    Set Analysis expression (nested?) help

    KHOA NGUYEN

      I need a sum of sales from associates whose SalesType is 'OutsideSales' **AND** if they have more than 10 rows of data.

       

          SELECT

               SUM(Sales)

          FROM table

          WHERE SalesType = 'OutsideSales'

          HAVING COUNT(*) > 10

       

      I have tried something like this...Not working:

       

      Sum({<SalesAssociate = {'$(=Count({<SalesType = {'OutsideSales'}>} SalesId) > 0)'}>}Sales)