https://community.qlik.com/t5/App-Development/Qlik-SumIf-Help/m-p/1949093#M78226 <P>The Data table contains all our sales transactions and we append a budget date to each record.</P> <P>We are effectively comparing current year day sales to a previous one (the linked date is variable so it is not always X number of days before/after another) hence why we append.</P> <P>The straight table needs a formula&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pm234567_0-1656421541535.png" style="width: 355px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82820i9B36499FD20547DF/image-dimensions/355x676?v=v2" width="355" height="676" role="button" title="pm234567_0-1656421541535.png" alt="pm234567_0-1656421541535.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 28 Jun 2022 13:15:34 GMT PFS_ITDept 2022-06-28T13:15:34Z https://community.qlik.com/t5/App-Development/Qlik-SumIf-Help/m-p/1949093#M78226 <P>The Data table contains all our sales transactions and we append a budget date to each record.</P> <P>We are effectively comparing current year day sales to a previous one (the linked date is variable so it is not always X number of days before/after another) hence why we append.</P> <P>The straight table needs a formula&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pm234567_0-1656421541535.png" style="width: 355px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82820i9B36499FD20547DF/image-dimensions/355x676?v=v2" width="355" height="676" role="button" title="pm234567_0-1656421541535.png" alt="pm234567_0-1656421541535.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 28 Jun 2022 13:15:34 GMT https://community.qlik.com/t5/App-Development/Qlik-SumIf-Help/m-p/1949093#M78226 PFS_ITDept 2022-06-28T13:15:34Z