Mortgage Formula is not working for me

[Isaiah_Harvey]

@Jeff_Hager

function calculateMonthlyPayment(interestRate, numberOfPayments, loanAmount) {
  const monthlyInterestRate = interestRate / 12;
  const compoundFactor = Math.pow(1 + monthlyInterestRate, numberOfPayments);
  const monthlyPayment = (loanAmount * monthlyInterestRate * compoundFactor) / (compoundFactor - 1);

  return monthlyPayment;
}

const interestRate = p1.toFixed(5); 
const numberOfPayments = p2.toFixed(5)*12;
const loanAmount = p3.toFixed(5);

return calculateMonthlyPayment(interestRate, numberOfPayments, loanAmount);

I really don’t know if it is me but I received this error message "Function Error

TypeError: p1.toFixed is not a function"

[Jeff_Hager]

@Isaiah_Harvey

TypeError: p1.toFixed is not a function

Can you show a screenshot of your javascript column configuration?

[Isaiah_Harvey]

@Jeff_Hager

function calculateMonthlyPayment(interestRate, numberOfPayments, loanAmount) {
  const monthlyInterestRate = interestRate / 12;
  const compoundFactor = Math.pow(1 + monthlyInterestRate, numberOfPayments);
  const monthlyPayment = (loanAmount * monthlyInterestRate * compoundFactor) / (compoundFactor - 1);

  return monthlyPayment;
}

const interestRate = p1.toFixed(5); 
const numberOfPayments = p2.toFixed(5)*12;
const loanAmount = p3.toFixed(5);

return calculateMonthlyPayment(interestRate, numberOfPayments, loanAmount);

Here is the Configuration.

[Jeff_Hager]

Is the calculation working otherwise, or not at all? Is there any chance that one of your values are empty in any of the rows in the table?

I can get the same error to pop up briefly, but only if I’m messing around with the values.

Sometimes the javascript column will show unhandled errors, or delayed errors that are no longer a problem.

I’m honestly not seeing anything wrong with your setup unless it’s something to do with your input values,but seeing that they are all numeric, I’m not sure what could be wrong.

[Isaiah_Harvey]

Yes, Unfortunately I can not figure it out. Thank you for you assistance and your time.