Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using this function only calculates the first record ...
Help please
Thanks John,
You have given me the solution.
But perhaps we can do something more simple.
The divider can leave it with a simple sum.
Thank you very much to all
sum(Amount)/sum(TOTAL<Total>aggr(sum(Amount),Total)
SUM(Amount) / AGGR(SUM(Amount), Total, Concepto)
Did you tried this ?
Sum(Amount)/Aggr(Sum(All Amount),Total)
Perhaps this?
sum(Amount)/aggr(nodistinct sum(Amount),Total)
If it isn't that simple, perhaps this?
sum(aggr(sum(Amount),Total,Concepto)
/sum(aggr(sum(Amount),Total)
Or maybe:
sum(aggr(sum( Amount),Total,Concepto)
/sum(aggr(sum(total <Total> Amount),Total,Concepto)
Thanks John,
You have given me the solution.
But perhaps we can do something more simple.
The divider can leave it with a simple sum.
Thank you very much to all
sum(Amount)/sum(TOTAL<Total>aggr(sum(Amount),Total)