Bug in the SUM

[zarmoton]

Hi

I need to have the value 1  (in the 3 rows) , and not 18 in SUM of MAX GRADE.

(1 is AMOUNT = -10 + 11)

I have wrote this expression , but not working:

= Sum({<GRADE = {"=Max(TOTAL <MyDate, [Site Number]> GRADE)"}> } TOTAL <MyDate, [Site Number]> AMOUNT)

Thk yu for your help

Regards

[zarmoton · Accepted solution]

I found it !

= Sum({<GRADE = {"=Max(TOTAL <MyDate, [Site Number]> GRADE)=GRADE"}> } TOTAL <MyDate, [Site Number]> AMOUNT)