Form not calculating correctly

  • Resolved theduck

    (@theduck)


    2 years ago

    I can’t figure out the issue as to why this form isn’t calculating the formula correctly. Someone enters the portfolio value. From there it calculates the management fee and ultimately the billed balance fee, however for amounts between 250-300 it doesn’t work. Which is odd since the field has a calculation between 250,000 and 500,000 – it seems to work over 300,000, but not below.

    that part of the management fee calculation: if(fieldname5 >= 250000 && fieldname5 < 500000) return PREC(0.014*100, 2);

    (Fieldname 5 being the portfolio amount)

    Billed balance fee calculation:

    if(fieldname4 >= 5000) return 0;
    if(fieldname4 < 5000) return (5000 – fieldname4);

    How could some of the amounts work, and others not in the same line?

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @theduck

    There is an issue in the settings of the fieldname4 fields (and other calculated fields). You let empty the decimal separator symbol. So, the plugin removes it and manages the value as a long integer number.

    Please, enter the decimal symbol (.) in the settings of the calculated fields.

    Best regards.

    Thread Starter theduck

    (@theduck)

    Thank you so much! I totally missed that.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Form not calculating correctly’ is closed to new replies.