Write an aggr expression

[#1]

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

[DavidFoster1 · Accepted solution]

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)

[rubenmarin]

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

[Anonymous]

Can you provide a sample data in excel  and output expected?