4 Replies Latest reply: Dec 1, 2017 8:06 PM by Sunny Talwar RSS

    Count if with aggr

    Siddharth Sheshadri

      I am trying to find the number of customers whose profit percentage is more than 50%

       

      Basically, count the number of customers whose (Profit/Total) > 50%

      What I tried is as follows but did not work:

       

      SUM(Aggr(IF(Profit/TotalSale>0.5,1,0),Customer))

       

      Suggestions please.