7 Replies Latest reply: Jul 19, 2018 12:12 AM by Louis Lam 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