InfoPath Dev

 Thanks for the reply and that link. I will be saving it as a favourite.  The above was from SharePoint, but I am using a custom InfoPath for and it doesn't work.  I'll give the filter tip a try.  Thanks again.  

 Hello, I'm brand new to InfoPath so sorry if this is a silly question.  What is the InfoPath equivalent IF statement? I searched the net and people have posted using rules but I'm not sure how I can get it to work. I'm trying to sum a total value:   =SUM(IF([Capped Home Value]>0,[Capped Home Value],[Home ...