General

Re: How to do mathematical operations

Matt Faus — Tue, 11 Jul 2006 02:12:04 GMT

Hi Patricia,

A little generous with those parentheses, huh? I think your problem is that you are trying to subtract date fields. I am pretty sure that this will almost always result in NaN, b/c IP treats date fields almost the same as strings. You will have to do calendar arithmetic in code.

Re: How to do mathematical operations

tricia — Mon, 10 Jul 2006 18:34:12 GMT

I'm in a similar kayak... in Preview Form I continue to receive NaN in the Client_Age field as soon as the application-date picker is used, and the Client_Age formula does not update when the Client_DOB is entered (yes, that check box is checked).

This simplest of simple formulas is to calculate the age based on application date less the DOB:
(((Application_date)) - ((Client_DOB))) div 365.25

I changed my default values to zero, didn't help nor did using the number function. This should be a no-brainer...
Tricia in Canada

Re: How to do mathematical operations

fgaona — Tue, 25 Apr 2006 17:46:53 GMT

Dear Abhishek my problem was more for data types, so I try to do my formulary in excel, but if I could´t I will like to send you and email with more details for help.
Thank you and see you for now.

quote:
Originally posted by Abhishek

Hi,
Can u give me some more details regarding what u r trying to do?
regards,
Abhishek

Re: How to do mathematical operations

Abhishek — Fri, 21 Apr 2006 07:09:57 GMT

Hi,
Can u give me some more details regarding what u r trying to do?
regards,
Abhishek

Re: How to do mathematical operations

fgaona — Thu, 20 Apr 2006 18:29:58 GMT

Dear Abhishek
your solution was close to solved my problem but if I place 0 as Default value, I dont´t know why but althought I put a formula in the data validation, this don´t recalculate the value with the formula for the field. I try to put the formula as a rule and in data validation but nothing happend
Regards

quote:
Originally posted by Abhishek

Hi,

Place 0 as the default value for the fields psalary and asalary and u wont get NaN anymore.

Regards,
Abhishek

Re: How to do mathematical operations

fgaona — Thu, 20 Apr 2006 16:50:27 GMT

Thanks Abhishek

quote:
Originally posted by Abhishek

Hi,

Place 0 as the default value for the fields psalary and asalary and u wont get NaN anymore.

Regards,
Abhishek

Re: How to do mathematical operations

Abhishek — Thu, 20 Apr 2006 04:42:26 GMT

Hi,

Place 0 as the default value for the fields psalary and asalary and u wont get NaN anymore.

Regards,
Abhishek

Re: How to do mathematical operations

fgaona — Wed, 19 Apr 2006 23:20:10 GMT

Hi Stephanie
Thank you very much for your help, you advice is just I needed, but now I have a second trouble, when I run (Preview) my form it sends me a red square with "NaN"(My Infopath is in Spanish).
And the problem that Infopath sends say like:
"The XML squema can´t validate the archive.

Union doesn´t admit the value.
It can´t analize the attribute 'snvariacion' with the value 'NaN'.
where 'snvariacion' is the field where I want to apper the result of the operation number(psalary)-number(asalary).
I appreciate if you have an other wonderful tip like the other.

quote:
Originally posted by scantwell

Hi FG,

you need to use number function for your psalary and asalary. ie. number(psalary)-number(asalary). Be sure to insert function number before you select your fields name.

Re: How to do mathematical operations

Stephanie Cantwell — Wed, 19 Apr 2006 19:56:58 GMT

Hi FG,

you need to use number function for your psalary and asalary. ie. number(psalary)-number(asalary). Be sure to insert function number before you select your fields name.

How to do mathematical operations

fgaona — Wed, 19 Apr 2006 18:27:59 GMT

Hi I need to do mathematical operations with fields like plus/minus operations, but when in the field properties->value I wrote a formula like d:psalary-d:asalary. This expression is not a valid formula, so I want to know how can I do this formula.
Thanks