This content has been marked as final. Show 3 replies
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.