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:

       

      1.

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

      2.

      Sum({$<EBIDTA={'<0'}>}Revenue).

       

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

       

      Please help me.