Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How I can achieve the following?
Thanks
Try this expression.
sum(total <vari_code>Aggr(sum(x)/sum(y),vari_code,no))
Regards,
Kaushik Solanki
I found it
sum(aggr(nodistinct
sum(x/y)
,vari_code))
I prefer to simplify the expression. Try:
Sum(TOTAL <vari_code> x/y)
And use 0 as the Null symbol to show 0 instead of null default symbol.
Try this....
Aggr(NODISTINCT Sum(x/y),vari_code)