General

Re: Add Squire root to a filed calculation?

motor1 — Thu, 09 Jan 2014 17:26:04 GMT

Thanks for the reply, but when i put in a value of let's say 10 it'll give me the correct result. but if i put in a value of .001 it'll give me result of 935.361047895519 which is wrong, the correct result should be 0.251188643

Re: Add Squire root to a filed calculation?

Jimmy — Thu, 09 Jan 2014 00:39:52 GMT

Yes, you can do this by replacing the formula on the Step field with this formula:

(4 * Result + Start / (Result * Result * Result * Result)) / 5

This is also very easy to calculate x ^ 1/5 using a single command in qRules:

concat("Pow /power=0.2 /value=", Field)

Re: Add Squire root to a filed calculation?

motor1 — Wed, 08 Jan 2014 17:42:30 GMT

anyway to do ^1/5 with this? if possible please let me know thanks much

Re: Add Squire root to a filed calculation?

sentinelace — Fri, 16 Dec 2011 14:48:07 GMT

yeah missed that. Added the rules and now works like a champ! Thanks for your help. Why couldn't they just add a square root button to infopath? LOL

Re: Add Squire root to a filed calculation?

Jimmy — Fri, 16 Dec 2011 04:56:48 GMT

Hello sentinelace,

It appears that you haven't defined any rules in the SquareRoot data source at all. You need to imitate all of the rules that I have on the Start and Step fields.

Also, I mentioned that I uploaded a simpler implementation than I had before. It looks like you still have the old one. Please download the newer one and use that (it doesn't have stop, Min, or Max fields).

Re: Add Squire root to a filed calculation?

sentinelace — Wed, 14 Dec 2011 13:57:22 GMT

I added that but the field does not populate any data. Just stays blank but your sample works. I have added the rules, etc. I noticed in yours there is resource files Squareroot1, and 2. I don't have those. I have the form and xml file in the same path. What am I missing?

Re: Add Squire root to a filed calculation?

Jimmy — Tue, 13 Dec 2011 21:39:35 GMT

Please redownload the ZIP as I've reposted a simpler approach.

You would add the XML file as a secondary data source. Then set up the rules the same way as they are in my example XSN. Then to set field1 = Square root of field 2, you would:

1. Set Start to the value of field2

2. Set field1 to the value of Result

That's it!

Re: Add Squire root to a filed calculation?

sentinelace — Tue, 13 Dec 2011 21:33:05 GMT

so how would I do:

field1 = Square root of field 2?

Re: Add Squire root to a filed calculation?

sentinelace — Tue, 13 Dec 2011 21:26:56 GMT

As long as I can get a field to display a square root I'm happy. I may need to apply it to several fields on the form. Where do I put these files exactly?

Re: Add Squire root to a filed calculation?

Jimmy — Tue, 13 Dec 2011 21:23:17 GMT

I'm not sure what you mean by "the square root instead of a decimel[sic] value." How is a square root an alternative to a decimal value?

At any rate, it's a bit convoluted but I'm attaching a form that performs a square root operation without any code at all. It makes use of a secondary data source, and the rules on the Start and Step fields in that data source. Best of luck.

Add Square root to a filed calculation?

sentinelace — Tue, 13 Dec 2011 20:06:40 GMT

I have two fields and I want to show the square root instead of a decimel value. How is this done? I found some C# and VB code that looks like it might work, but I am not sure where to put the code. Any help appreciated.