Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
I divided the weight in classes of 2 like this:
=Class(emptyings_adjusted_weight),2)
Actually I need the sum of the weight, how do I write that?
I tried:
=Class(aggr(sum(emptyings_adjusted_weight)),2)
Anyone else better ideas?
Kind regards,
Katleen
The aggr statement needs at least one dimension as the second parameter to provide the 'group by' context for the sum.
So it should be something like:
=Class(aggr(sum(emptyings_adjusted_weight),[Widget]),2)
The aggr statement needs at least one dimension as the second parameter to provide the 'group by' context for the sum.
So it should be something like:
=Class(aggr(sum(emptyings_adjusted_weight),[Widget]),2)
Not sure about what you are searching but aggr needs the fields.
Aren't you searching something like =Class(sum(emptyings_adjusted_weight),2) ?
Regards
Can you provide a sample data in excel and output expected?