Newbie Questions

Re: IF statement in infopath

Jmills — Thu, 09 Oct 2014 02:19:29 GMT

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.

Re: IF statement in infopath

Hilary Stoupa — Wed, 08 Oct 2014 23:33:59 GMT

It is not a silly question - but there is no such thing as an "if" statement in InfoPath. I'm guessing the above is from Excel?

You can add a filter to the data you wish to total - you'd select the field using the field picker and add a filter by clicking the "filter data" button.

Here is a link to an overview of InfoPath functions that may help you get started writing formulas in InfoPath: http://office.microsoft.com/en-us/infopath-help/functions-in-infopath-HP001155281.aspx

IF statement in infopath

Jmills — Wed, 08 Oct 2014 23:29:27 GMT

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 Value])+IF([RV Capped Value]>0,[RV Capped Value],[RV Value])+[Assessable Income Streams]+[Bank Accounts])

I get an error when I put that it the formula box.

Any guidance greatly appreciated.

Thanks,

Jeremy