InfoPath Dev

I am creating a Graduation Plan Infopath form. I am having trouble coming up with an expression to calculate the credits earned.

Students earn credits by course in two semesters. This are the scenarios:

pass-pass
Passing the first semester, half of the credits are earned. Passing the second semester the other half of the credits are earned.

fail-pass
Failing the first semester, but passing the second semester full credit are earned. 

pass-fail
Passing only the first semester, gives half of the credits.

fail-fail
Failing both semesters results on 0 credits earned. 

Examples:

I created this on a section inside a repeating table. This is how the form looks like:

I was thinking on setting a default value on the 'fallCredit' and 'springCredit' fields using the eval function. Unfortunatley, I haven't been able to understand how to use XPath expressions.

Can you please help?

Hi - do you mind attaching a sample form under the Options tab that has the data structure you are displaying above? I'd be happy to give this a try, but it would save me some time to have the schema already created....

I disabled your rules on field A and field B. I used the following formula as a default for "earned" - since I am not terribly math-y, it most likely has more parenthesis than it needs. :)

(((A >= passing) * courseCredits) / 2) + (((B >= passing) * courseCredits) / 2)

Basically, the first boolean condition evaluates to one or zero. I multiply that by course credits and divide by 2 to get the course credits for A. Then I add that to the same logic for B.

I've attached your template. Save it locally, then you can right click and select Design to open in design mode & preview.

Thansk for your post, it works like a charm. I see how you created the formula. It will help me learn how to solve more problems. Thanks a bunch!

It solves my scenario pass-pass. I still wondering how to make it work in a way it can conditionally solve the other scenarios. Is there an 'if' function?

In the sample form, if I fill it out with your sample data from your original post, it appears to exactly meet your requirements. Can you tell me how the formula is not working for your other scenarios?

Ah, I see - I misunderstood the scenario where they fail first semester but pass the second. I'll see what I can come up with.

Okay, I modified the default formula to handle for the fail -> pass scenario.

(((A >= passing) * courseCredits) / 2) + (((B >= passing) * courseCredits) / (2 - ((A < passing) and (B >= passing))))

See attached template, I'll post a screenshot with the data as well.

Here's a screenshot showing the form with data entered to match your original data....