https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/93896.aspxThu, 24 Oct 2013 23:28:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:93896Doreen0https://www.infopathdev.com:443/forums/thread/93896.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=93896<p>I am not sure about this but try&nbsp;modifying &nbsp;your SharePoint default view&nbsp;with fuel usage column to&nbsp;descending,and set number of rows displayed to 365 then in your rules choose a condition,&nbsp;maybe on form load behavior, to sum @fuelusagecolumn where number of occurances&nbsp; &nbsp;&lt; 366?&nbsp; </p>https://www.infopathdev.com:443/forums/thread/93894.aspxThu, 24 Oct 2013 19:46:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:93894Healios560https://www.infopathdev.com:443/forums/thread/93894.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=93894<div class="usertext-body"><div class="md"><p>I am a newer user to Sharepoint 2010 and Infopath 2010. On my current form, users are asked how much fuel was used. This value is recorded into a Sharepoint form library. What I also need a field that displays the past 365 days worth of fuel usage. So take today entry add it to the running total, and drop the value that is over 365 days old. Is it possible to set a Sum(interval or something for this? Any tips to set this up? or a good blog to check out.</p> <p>Thank you for the help.</p> </div> </div>