condition for revenue at negative EBITDA

[divyanshi]

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.

[arulsettu]

can you post your qvf and expected output.

[arvind_patil]

Hi Divyanshi,

I think you are missing something at the time of group by in expression.

Thanks,

Arvind Patil

[divyanshi]

thanks it get done