Sum Distinct

[danielnevitt]

Dear all,

I have the attached data and would appreciate some help calculating the sum of the abs_pos_vol by distinct our_reference.

The values are slightly different, however I am happy to sum either the lower or higher value.

Thanks,
Daniel

[sunny_talwar]

May be this for max

Sum(Aggr(
  Max(Aggr(
    abs_pos_vol
  , our_reference))
, our_reference))

 or this for Min

Sum(Aggr(
  Min(Aggr(
    abs_pos_vol
  , our_reference))
, our_reference))

[danielnevitt]

Hi Sunny,

Thanks for the quick reply.

Unfortunately that doesn't work though.  The expression just returns a blank value.

Regards,
Daniel

[sunny_talwar]

What is abs_pos_vol? a field or expression?

[danielnevitt]

abs_pos_vol is a numeric field.

Regards
Daniel

[sunny_talwar]

Sum(Aggr(
  Min(Aggr(
    abs_pos_vol
  , our_reference, abs_pos_vol))
, our_reference))

[Brett_Bleess]

Daniel, did Sunny's last post get you what you needed?  If so, please do not forget to close out your thread by using the Accept as Solution button on that post of Sunny's to do so.  This also gives him credit for the assistance and will let other Members know it worked.  If you did something different, you can post what you did and then mark that, but please be sure to close this out if possible.

Regards,
Brett