6 Replies Latest reply: Mar 29, 2012 5:54 AM by Celambarasan Adhimulam RSS

    Sum Conditional in Set Analysis

    Hamish Imrie

      HI,

       

      This statement seems to not be working at all

       

      =count({<{$(=sum(InvoiceFlag))}={'$(>1)'}>} distinct  CompanyID)

       

      The aim of the expression is to count the CompanyID's where the sum of the invoice flags is greater then 1.

       

      Regards