Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
can you post your qvf and expected output.
Hi Divyanshi,
I think you are missing something at the time of group by in expression.
Thanks,
Arvind Patil
thanks it get done