3 Replies Latest reply: Aug 1, 2017 4:50 AM by Divyanshi Bansal RSS

    condition for revenue at negative EBITDA

    Divyanshi Bansal

      I need to calculate Revenue at negative EBITDA corresponding to customers and leaders.

      And we have 100s of customer under one leader.

      The expression I used as below:



      if((aggr(sum(EBIDTA),leaders,[Customer Group Descr]))<0,sum(Revenue))




      The values corresponding to individual customers are correct but Total is not correct.


      Please help me.