General

Re: Math Problem

smonczka — Thu, 07 Nov 2013 17:36:28 GMT

Yes it makes total sence, thank you!

Re: Math Problem

Hilary Stoupa — Thu, 07 Nov 2013 00:28:58 GMT

You got it. So - one thing it took me a while to understand but that is very important is that rules only execute when the field they are on changes. When you check the box, there is nothing in units. We don't want to run the rule if there is nothing in units, so we add a condition to protect about that. When you change units, if the box is checked, we want to run the same rule. So - the rule depends on Units & on the checkbox, thus the rule needs to be on both fields, and conditions need to take both fields into account. Make sense?

Re: Math Problem

smonczka — Thu, 07 Nov 2013 00:08:27 GMT

Hilary, Thank you so much! I see what you did but why did that fix it? Is it because the rules only run on update to the field. So you would check off the box, the rule would run but there was nothing in the Unit field. So you added the rules to the unit field so when the unit field is updated the rule runs again?

Re: Math Problem

Hilary Stoupa — Wed, 06 Nov 2013 15:05:25 GMT

When you reply to a post, one of the tabs is Options. You can attach a file under the Options tab. Here's your example back - I've added additional conditions and rules (checkbox & units field).

Re: Math Problem

smonczka — Wed, 06 Nov 2013 02:14:27 GMT

Hillary I do need your help. If you open the link below (I see no way of attaching files in this forum) you will see what the issue is.

There are several rows in the form just like this one. The user checks off a row and then populates the number of unites. The last field is the total of Hours / Units. A rule runs when the check box is checked If True then total = Hours / Units. If false then total = 0.


	Example.xsn

Re: Math Problem

Hilary Stoupa — Wed, 06 Nov 2013 01:56:37 GMT

I'm confused - where are you putting the formula? As a default in Field A? B? C? Maybe attach a sample form and un-confuse me? :)

Re: Math Problem

smonczka — Wed, 06 Nov 2013 00:14:01 GMT

Hilary that worked, but I have developed another issue, unrelated to the first.

Field A / Field B = Field C

Returns Error "Infiniti"

Not sure why this is happening. If A = 4 and B = 2 C should = 2 But I get an error. If I go into the text box properties of C and put in the formula 4 / 2 it works. But if I put in the properties of the text box (fieldA / fieldB) I get an error.

Re: Math Problem

Hilary Stoupa — Tue, 05 Nov 2013 23:40:42 GMT

It doesn't appear to me that this would be a divide by zero error - you are dividing by .5, right? At any rate, maybe try adding an XPath filter on B.

C = A + ((B[. != ''] + A) / .5)

Math Problem

smonczka — Tue, 05 Nov 2013 16:54:34 GMT

Having an issue trying to write a formula for a field.

I have three cells A B C

A = Hours for Job 1 (there will always be a number in this field)

B = Hours for Job 2 (there may not be an entry for this field)

C = A + ((B+A) /.5)

The issue comes in when there is no entry for field B (B =0). Then I get NaN because you can't divide by 0.

Thanks