Sum values based on ID

[samantha92]

Hi,

I am having an issue with creating the following expression.

I need to group together any individuals who have more than 1 row of data

I then need to sum a value and only show if it is more than 8.5

So far I have tried the following:

if(sum(XYZ>=8.5), XYZ) 

But this does not group together the total if a person has more than 1 row of data (null values are those with more than 1 row of data)

Hope this makes sense!

Any help is appreciated.

Thanks

[sunny_talwar · Accepted solution]

May be this

Sum({<Surname = {"=Sum(XYZ) >= 8.5"}>} XYZ)

[samantha92]

Thank you that works great - one more question...

How would I take the value of those people who are over 8.5 and do a count?

Thanks

[sunny_talwar]

May be this

Count(DISTINCT {<Surname = {"=Sum(XYZ) >= 8.5"}>} Surname)

[samantha92]

That's fab thank you!!