exponents in InfoPath 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

grant galloway - 02 Apr 2008 20:08 GMT

how in the world to I include exponents into a formula in Infopath 2007.
something simple like 5^3. for some reason, the carrot "^" is not a valid
symbol. please help!!!

Reply to this Message

Clay Fox - 02 Apr 2008 21:36 GMT

I do not think exponents would be supported. You may have to treat them as
text if you want it presenved or for math do the numbers the long way.

Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> how in the world to I include exponents into a formula in Infopath 2007.
> something simple like 5^3. for some reason, the carrot "^" is not a valid
> symbol. please help!!!

Reply to this Message

grant galloway - 02 Apr 2008 22:11 GMT

i was actually trying to do a formula like 2.2^1.364
maybe i can link the form back to access and calculate it that way.

> I do not think exponents would be supported. You may have to treat them as
> text if you want it presenved or for math do the numbers the long way.
>
> > how in the world to I include exponents into a formula in Infopath 2007.
> > something simple like 5^3. for some reason, the carrot "^" is not a valid
> > symbol. please help!!!

Reply to this Message

Gavin McKay - 03 Apr 2008 05:16 GMT

Hello,

You should be able to hook your field up to a .NET code-behind function to
calculate this using the System.Math class. Then you could have the function
calculate after a change to other fields to get your final results. That
would be far less painful that calling out to Access IMHO.

HTH

Gavin.

Signature

2B | !2B

> i was actually trying to do a formula like 2.2^1.364
> maybe i can link the form back to access and calculate it that way.
[quoted text clipped - 5 lines]
> > > something simple like 5^3. for some reason, the carrot "^" is not a valid
> > > symbol. please help!!!

Reply to this Message