use exponential functions in ui-only field to the power of

[Dave]

@Jack_Sanford

I’d like to be able to use “to the power of” exponential functions in a UI-only field. Use case is estimating a payment amount on the front end of a public site. We have a formula field to do this, but the formula is blank until the record is saved, I’d like to show the calculation before saving. But it requires, in particular, this formula: “(1+ MonthlyInterest__c ) ^ NoofPayments2__c”, where the ^ symbol represents “to the power of”.

Would be great to see that as an option in the UI-only dropdown list of Operators.

In the mean time, any way to hack this?

@jacksanford Hi, not sure if you ever succeeded in accomplishing this above. As i have now a very similar requirement and need to use EXP excel function. if you did and could share the way you did it, or JS you used (if any) that would be amazing!

Let me know

Thx