General

Re: How to calculate Sums Square in InfoPath 2010

Jimmy — Thu, 09 Jan 2014 00:50:26 GMT

Are you looking to calcualte something like described above using the 5th power (e.g. (a^5 + b^5 + c^5) ^ (1/5), or just compute the 5th root? If it's the latter, I replied here:

http://www.infopathdev.com/forums/p/21041/95090.aspx#95090

Re: How to calculate Sums Square in InfoPath 2010

motor1 — Wed, 08 Jan 2014 17:40:53 GMT

anyway to modify this to make it do ^1/5 ? will be the world to me if this is possible thanks

Re: How to calculate Sums Square in InfoPath 2010

rookie — Sat, 08 Dec 2012 16:38:49 GMT

I do appreciate you taking your time with this. I think I can get it to work, but I need your expertise on how you used the XML document to solve for (square root) in a previous forum. By using a (rule) I can calculate the (sums square) for each cell in a repeating cell. Now this field won't be shown in the document, its pearly a place holder for the (sums square) calculation. Now if i can use your XML technique to calculate the square root this would be the shown value in the document. I have an example but I don't see where I upload document to this forum. Form layout: 1 repeating table = Sum 1 Text field = Sum_Square (value place holder) Rule1 = Action, Set a Field's Value, Field = Sum_Square, Value = sum(eval(Sum,Sum_Square * Sum_Square)) 1 Text field = Sum_Square_Root (Shown in form) Calculate Sum_Square using XML Square Root document. Hope this makes sense.

Re: How to calculate Sums Square in InfoPath 2010

Jimmy — Fri, 07 Dec 2012 20:11:33 GMT

qRules is a software package that you can add to your InfoPath forms to extend their functionality far beyond the built-in features that InfoPath provides. In our latest release, we added a large number of math, financial, and string processing functions.

You can learn more about qRules here:

http://www.qdabra.com/en/products/qRules_new.aspx

Re: How to calculate Sums Square in InfoPath 2010

rookie — Fri, 07 Dec 2012 17:11:53 GMT

I did try it, and it works the way I would expect it to work, But let me clarify, I should of said (Root Sums Squared): 1. square each row separately, 2. add all of the square's together, 3. and then square root the total. What is qRules? thanks for your help.

Re: How to calculate Sums Square in InfoPath 2010

Jimmy — Fri, 07 Dec 2012 16:41:07 GMT

No, my formula computes the sum of the squares, just like you asked. Did you try it?

Your first post didn't mention taking the square root of the end result. InfoPath doesn't provide built-in square root capability. I posted a (somewhat involved) codeless square root implementation in this forum:

http://www.infopathdev.com/forums/p/21041/72904.aspx#72904

But really, the best way to get extra math functionality is to use qRules.

Re: How to calculate Sums Square in InfoPath 2010

rookie — Fri, 07 Dec 2012 15:57:23 GMT

Thanks for the reply but that isn't what I'm looking for. Your equation is adding all of the rows and then squaring the number. What I'm looking for is: Row 1 = .005 Row 2 = .010 Answer = (.005 Square + .010 Square) square root

Re: How to calculate Sums Square in InfoPath 2010

Jimmy — Fri, 07 Dec 2012 14:55:24 GMT

It would be

sum(eval(Field, ". * ."))

How to calculate Sums Square in InfoPath 2010

rookie — Fri, 07 Dec 2012 12:39:21 GMT

Is it possible to calculate Sums Square on a repeating table in InfoPath 2010. If so, how does one go about doing the calculation? Thanks.