General

Re: Help to create a formula using the eval function in InfoPath 2010

Hilary Stoupa — Wed, 08 Aug 2012 22:54:52 GMT

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

Re: Help to create a formula using the eval function in InfoPath 2010

Hilary Stoupa — Wed, 08 Aug 2012 22:53:11 GMT

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.

Re: Help to create a formula using the eval function in InfoPath 2010

Hilary Stoupa — Wed, 08 Aug 2012 15:58:52 GMT

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.

Re: Help to create a formula using the eval function in InfoPath 2010

Hilary Stoupa — Wed, 08 Aug 2012 15:57:04 GMT

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?

Re: Help to create a formula using the eval function in InfoPath 2010

Edwin Brito — Wed, 08 Aug 2012 01:38:47 GMT

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?

Re: Help to create a formula using the eval function in InfoPath 2010

Hilary Stoupa — Mon, 06 Aug 2012 14:59:09 GMT

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.

Re: Help to create a formula using the eval function in InfoPath 2010

Edwin Brito — Sat, 04 Aug 2012 12:06:12 GMT

I uploaded the form. Thanks :-)

Re: Help to create a formula using the eval function in InfoPath 2010

Hilary Stoupa — Wed, 01 Aug 2012 23:49:48 GMT

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....

Help to create a formula using the eval function in InfoPath 2010

Edwin Brito — Tue, 31 Jul 2012 02:46:58 GMT

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:

				First Sem		Second Sem
	Course	Passing Gr	Credits	A	Fall Credit	B	Spring Cr	Accumulated
	Course	Passing Gr	Credits	(Fall Gr)	Fall Credit	(Spring Gr)	Spring Cr	Accumulated
pass-pass	English I	70%	4	71%	2	71%	2	4
fail-pass	English I	70%	4	69%	0	71%	4	4
pass-fail	English I	70%	4	71%	2	69%	0	2
fail-fail	English I	70%	4	69%	0	69%	0	0

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?