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/38975.aspxThu, 26 Feb 2009 15:08:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:38975murphythadog0https://www.infopathdev.com:443/forums/thread/38975.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=38975<p>Well, since I&#39;ve finished my first infopath form I wanted to see where it could actually help me in my day to day routines.&nbsp; I have an excel spreadsheet of all my Mobile Devices for my office.&nbsp; I have a few tabs and it calculates the number of Blackberry License that I have used.&nbsp; It keeps track of Contracts End Dates and Donated Devices. &nbsp;</p><p>What I&#39;ve done so far is replicate the Excel spreadsheet into Infopath.&nbsp; What I wanted to do is Under Location put in a filter for each View.&nbsp; If the filter contains Donated it will show in the Donated View.&nbsp; On the (Verizon View) I have a filter that says show all that do not contain Donated.&nbsp; For some reason when I input my first set of data it will works perfectly.&nbsp; My first line shows on the Verizon View and then it does not appear on my Donated View.&nbsp; Then I insert another line and it shows in both spots.&nbsp; Maybe I have my filter on the wrong area.&nbsp; I filtered based on the repeating table under location.&nbsp; My locations would either be office locations, or it will be designated Donated.&nbsp; </p><p>Another problem I&#39;m having is I have a count, it counts the number of Blackberry Devices.&nbsp; For some reason on the Views it counts the Donated items that are not appearing on the particular view as taking up a license Is there a way to only count on a particular view? &nbsp; </p><p>&nbsp;</p><p>So far I&#39;ve found this but it doesn&#39;t seem to help my situation:&nbsp; <a href="http://support.microsoft.com/kb/870843" title="Filter data">http://support.microsoft.com/kb/870843&nbsp;</a></p><p>&nbsp;Well, I see in the preview of the form you can do a refresh filter.&nbsp; I guess what this accomplishes is that you don&#39;t have data automatically disappear on you.&nbsp; I guess I can live with this.&nbsp; It&#39;s still counting the filtered data, I searched the forums and there was someone who touched on it, so I copied the formula into my formula but it didn&#39;t work.&nbsp; They were saying you have to filter out the data in your formula.&nbsp; Not really sure how to do this. &nbsp; <br /></p><p>&nbsp;I keep getting an error that says Cannot place filter in this field choose another field.&nbsp; <br /></p><p>&nbsp;</p>