https://community.qlik.com/t5/Management-Governance/Error/m-p/2003607#M23729 <P>Hi, I have one mistake in my formula, but I don't know what's the issue.</P> <P>=num(sum({&lt; SNAP_SHOT_DATE={'$(=[ReportDate])'}, [Status Code]={'1','2','3','4','5','6'} ,VALUE_CALENDAR_YEAR ={'$(=[Filteryear])'} ,DATETYPE = { 'A'}&gt;}[Idea Sav at Confidence|DS0])/1000000<BR />-sum({&lt; SNAP_SHOT_DATE={'$(=(Max({&lt;ReportDate={'$(='&lt;'&amp;(only(ReportDate)))'}&gt;} ReportDate)))'}, [Status Code]={'1','2','3','4','5','6'} ,VALUE_CALENDAR_YEAR ={'$(=[Filteryear])'}<BR />,DATETYPE = { 'A'}&gt;}[Idea Sav at Confidence|DS0])/1000000,'0.$(vDecimalPlaces);(0.$(vDecimalPlaces))')</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="thiguiii_1-1668178346940.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/93514iB603C1D23355D868/image-size/medium?v=v2&amp;px=400" role="button" title="thiguiii_1-1668178346940.png" alt="thiguiii_1-1668178346940.png" /></span></P> <P>&nbsp;</P> Fri, 11 Nov 2022 14:52:43 GMT thiguiii 2022-11-11T14:52:43Z https://community.qlik.com/t5/Management-Governance/Error/m-p/2003607#M23729 <P>Hi, I have one mistake in my formula, but I don't know what's the issue.</P> <P>=num(sum({&lt; SNAP_SHOT_DATE={'$(=[ReportDate])'}, [Status Code]={'1','2','3','4','5','6'} ,VALUE_CALENDAR_YEAR ={'$(=[Filteryear])'} ,DATETYPE = { 'A'}&gt;}[Idea Sav at Confidence|DS0])/1000000<BR />-sum({&lt; SNAP_SHOT_DATE={'$(=(Max({&lt;ReportDate={'$(='&lt;'&amp;(only(ReportDate)))'}&gt;} ReportDate)))'}, [Status Code]={'1','2','3','4','5','6'} ,VALUE_CALENDAR_YEAR ={'$(=[Filteryear])'}<BR />,DATETYPE = { 'A'}&gt;}[Idea Sav at Confidence|DS0])/1000000,'0.$(vDecimalPlaces);(0.$(vDecimalPlaces))')</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="thiguiii_1-1668178346940.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/93514iB603C1D23355D868/image-size/medium?v=v2&amp;px=400" role="button" title="thiguiii_1-1668178346940.png" alt="thiguiii_1-1668178346940.png" /></span></P> <P>&nbsp;</P> Fri, 11 Nov 2022 14:52:43 GMT https://community.qlik.com/t5/Management-Governance/Error/m-p/2003607#M23729 thiguiii 2022-11-11T14:52:43Z https://community.qlik.com/t5/Management-Governance/Error/m-p/2003680#M23732 <P>Maybe this?</P> <P>SNAP_SHOT_DATE={'$(=(Max({&lt;ReportDate={"&lt;=$(=Only(ReportDate))"}&gt;} ReportDate)))'}</P> Fri, 11 Nov 2022 18:24:44 GMT https://community.qlik.com/t5/Management-Governance/Error/m-p/2003680#M23732 BrunPierre 2022-11-11T18:24:44Z