7 Replies Latest reply: Jul 19, 2018 12:12 AM by Louis Lam RSS

    Sum Conditional in Set Analysis

    Hamish Imrie



      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.