18 Replies Latest reply: Feb 15, 2017 12:49 PM by Sunny Talwar RSS

    Doubt regarding a formula withSET ANALYSIS OR AGGR

    pedro juarez

      Hi

       

      I don't know if my problem have to be solved with what option: i have to count the number of invoices that in the total have 3 units or less units invoiced.

       

      I had tried with these 2 options but for some reason they don't work. On the other hand I don't know which is the best option of them to solve this problem, could you explain why???

       

      the formulas that I wrote are these:

       

      formula 1: Count(AGGR(SUM([UN VENDIDAS])<=3, NUM.FACTURA)) - this formula is not working well because its counting the invoices that have lines with 3 or less units instead of just counting the invoices that have 3 or less units in the total.

       

      formula 2: Count({< Sum ([UN VENDIDAS])<=3 >} DISTINCT NUM.FACTURA) - this formula is showing error in the syntaxis

       

      Thanks for your help

      Regards,

      PMJT