General

Re: Sum Multiple Fields

ebonymb — Tue, 31 Jul 2012 16:02:34 GMT

I figured it out. http://www.infopathdev.com/forums/t/11349.aspx The problem was with floating arithmetic. I thought it was weird that the problem occurred randomly and out of 20 or so requests, this was the first time it had happened. I was able to resolve it with the following formula. (PRIN + INT + ANNUAL + LATE + OtherFees) * 100 / 100

Re: Sum Multiple Fields

Hilary Stoupa — Tue, 31 Jul 2012 15:19:10 GMT

Have you saved your XML and looked at it in a text editor? I have a feeling your other controls may be set to display only two decimal places and PRIN and INT are not the values you think they are - that the formatted and actual values are different.

Re: Sum Multiple Fields

ebonymb — Tue, 31 Jul 2012 14:27:32 GMT

I have a formula to to sum 5 fields which are all set to data type Decimal (double), Currency format, and 2 decimals. The total field formula = sum(PRIN) + sum(INT) + sum(ANNUAL) + sum(LATE) + sum(OtherFees)

For some reason, when PRIN = 2.90, INT - 1.03, and all other fields = 0.00, the total sums as 3.9299999999999997 instead of 3.93.

The issue has not occurred on other sum totals so far. Any idea why it isn't calculating 3.93?

Re: Sum Multiple Fields

joeyjackson — Thu, 07 Jun 2012 12:41:24 GMT

Thanks - it seems like it should be more complicated that that for some reason.

Re: Sum Multiple Fields

Fierhauk — Wed, 18 Jan 2012 19:59:49 GMT

Every time i need an answer on InfoPath or qRules it's a Hilary post that has it.

A couple years before i needed it, but thanks!

Re: Sum Multiple Fields

Hilary Stoupa — Wed, 17 Mar 2010 23:20:55 GMT

Just use a formula for the default value for your "Total" field and use the Insert field or group button to select each of your fields. Then put a + sign between the fields....

Sum Multiple Fields

nobbsy — Wed, 17 Mar 2010 23:15:51 GMT

Hi,

I think this is a simple one. I have 5 seperate fields, each with a value in them. I have another field called "Total". How did I sum all the 5 seperate fields to put the total in the "Total" field.

Thanks