Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5881
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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