• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6079
  • Last Modified:

InfoPath 2007. How to do an if Statement in an infopath form to calculate a value.

Browser-based form. I want people to fill out an expense form. There is an ExpenseDate field, a Mileage field, and a Mileage Allowance field.  If the ExpenseDate is < 1/1/2009 then I need the MileageAllowance field to show Mileage * 0.585  else Mileage * 0.55.

InfoPath doesn't use straightforward if statements. Please help.
InfoPathForm.jpg
0
CLP-ITT
Asked:
CLP-ITT
1 Solution
 
Robbie_LeggettCommented:
Have a look at the screenshots. It's easier than you think.
I did it in the rules of the date field so the event fires when a date is entered.
:-)

Infopath1.jpg
Infopath2.jpg
0
 
CLP-ITTAuthor Commented:
Thank you! I'm new to InfoPath (obviously) and that was exactly what I needed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now