https://community.qlik.com/t5/QlikView/Bug-in-the-SUM/m-p/1700472#M451178 <P>Hi</P><P>I need to have the value 1&nbsp; (in the 3 rows) , and not 18 in SUM of MAX GRADE.</P><P>(1 is AMOUNT = -10 + 11)</P><P>I have wrote this expression , but not working:</P><P>= Sum({&lt;GRADE = {"=Max(TOTAL &lt;MyDate, [Site Number]&gt; GRADE)"}&gt; } TOTAL &lt;MyDate, [Site Number]&gt; AMOUNT)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 05-10-20 at 01.59 PM.PNG" style="width: 601px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33287iED7223B2A0348D08/image-size/large?v=v2&amp;px=999" role="button" title="Screen Shot 05-10-20 at 01.59 PM.PNG" alt="Screen Shot 05-10-20 at 01.59 PM.PNG" /></span></P><P>&nbsp;</P><P>Thk yu for your help</P><P>Regards</P> Sun, 10 May 2020 11:05:26 GMT zarmoton 2020-05-10T11:05:26Z https://community.qlik.com/t5/QlikView/Bug-in-the-SUM/m-p/1700472#M451178 <P>Hi</P><P>I need to have the value 1&nbsp; (in the 3 rows) , and not 18 in SUM of MAX GRADE.</P><P>(1 is AMOUNT = -10 + 11)</P><P>I have wrote this expression , but not working:</P><P>= Sum({&lt;GRADE = {"=Max(TOTAL &lt;MyDate, [Site Number]&gt; GRADE)"}&gt; } TOTAL &lt;MyDate, [Site Number]&gt; AMOUNT)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 05-10-20 at 01.59 PM.PNG" style="width: 601px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33287iED7223B2A0348D08/image-size/large?v=v2&amp;px=999" role="button" title="Screen Shot 05-10-20 at 01.59 PM.PNG" alt="Screen Shot 05-10-20 at 01.59 PM.PNG" /></span></P><P>&nbsp;</P><P>Thk yu for your help</P><P>Regards</P> Sun, 10 May 2020 11:05:26 GMT https://community.qlik.com/t5/QlikView/Bug-in-the-SUM/m-p/1700472#M451178 zarmoton 2020-05-10T11:05:26Z https://community.qlik.com/t5/QlikView/Bug-in-the-SUM/m-p/1700483#M451179 <P>I found it !</P><P><SPAN>= Sum({&lt;GRADE = {"=Max(TOTAL &lt;MyDate, [Site Number]&gt; GRADE)=GRADE"}&gt; } TOTAL &lt;MyDate, [Site Number]&gt; AMOUNT)</SPAN></P> Sun, 10 May 2020 14:01:00 GMT https://community.qlik.com/t5/QlikView/Bug-in-the-SUM/m-p/1700483#M451179 zarmoton 2020-05-10T14:01:00Z