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

  • 3
  • Idea
  • Updated 4 years ago
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?
Photo of Jack Sanford

Jack Sanford, Champion

  • 9,766 Points 5k badge 2x thumb

Posted 4 years ago

  • 3
Photo of Matt Sones

Matt Sones, Champion

  • 32,106 Points 20k badge 2x thumb
You could build a quick custom field renderer in javascript and use Math.pow().