To the Power

[GR44]

In Crystal, is there a function/way to take a field to a power? (i.e. {interest_rate] to the [x] power)

 

[synapsevampire]

The Exponentiation operator is ^.

3^2 = 9

If that's not what you seek, let me know.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Naith]

{Interest_Rate} ^ x does this.

 

[GR44]

Thank you for your feedback. I tried using the ^ character but got a "The remaining text does not appear to be part of the formula" error. Below is the formula:

({@Market_Price}*1.12)^((round(({optstmt_view.Grant_Expiration_Date}-AsofDate)/365),0)

Here I'm trying to take the Market Price to a power. The power is calculated as the difference between two dates and divided by 365 to get a year equivalent.

Thanks again for your help.

 

[Naith]

Should it not be:

({@Market_Price}*1.12) ^ (Round(({optstmt_view.Grant_Expiration_Date}-AsofDate),0)/365)

As it is, the formula is struggling with /365 as a component of the Round function.

Naith