Present Value Calculator

  • Resolved Louis Wolmarans

    (@louiswol94)


    8 years, 7 months ago

    Hi guys,

    I need some help please.

    Please view the calculator on this page: https://drufftest.co.za/Select-Africa/kenya/

    This is my formula on the “PV” field:

    PRESENTVALUE(0.65/12,<%fieldname5%>,<%fieldname7%>)

    Repayment term = <%fieldname5%>
    Installment amount = <%fieldname7%>

    So the PV answer must display automatically when the “Installment amount:” field and “Repayment term (months):” field are filled in.

    When I put another formula in like:

    PRESENTVALUE(0.65/12,24,500)

    – then it works fine. But I need the PV to calculate with variables <%fieldname5%> and <%fieldname7%>

    Thanks

    https://www.ads-software.com/plugins/calculated-fields-form/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter Louis Wolmarans

    (@louiswol94)

    HI.

    I see it works if I add the formula like so:

    PRESENTVALUE(0.65/12,fieldname5,fieldname7)

    But one more question please:

    How do I round off to two decimals?

    I want 6502.12 to display instead of 6502.12321312 for example

    Thread Starter Louis Wolmarans

    (@louiswol94)

    One more question as well:

    My destination e-mails are set to:

    [email protected],<%fieldname12%>

    [email protected] does receive the e-mail

    <%fieldname12%> does NOT receive the e-mail.

    <%fieldname12%> is a calculated value with a placeholder of [email protected] – and it’s hidden from public view.

    I also do not want <%fieldname12%> to display on the e-mail that the user receives.

    Thread Starter Louis Wolmarans

    (@louiswol94)

    I have sorted out the decimals using

    PREC(PRESENTVALUE(0.65/12,fieldname5,fieldname7),2)

    Now it’s just the e-mail issue.. Quote from previous post:

    “My destination e-mails are set to:

    [email protected],<%fieldname12%>

    [email protected] does receive the e-mail

    <%fieldname12%> does NOT receive the e-mail.

    <%fieldname12%> is a calculated value with a placeholder of [email protected] – and it’s hidden from public view.

    I also do not want <%fieldname12%> to display on the e-mail that the user receives. ”

    Thread Starter Louis Wolmarans

    (@louiswol94)

    Sorry guys one more question:

    I have the Developer License.

    How can I make a page or area where admins can see the submitted details?

    In the back-end or on a page or something…

    Thanks.

    Plugin Author codepeople

    (@codepeople)

    Hi,

    In the equations you should not use the tag’s format, so the equation would be:

    PRESENTVALUE(0.65/12,fieldname5,fieldname7)

    If you want to return the result with two decimal places, you should use the “PREC” operation.

    PREC(X,Y) returns the X number rounded to Y decimal places.

    So, the equation should modified as follows:

    PREC(PRESENTVALUE(0.65/12,fieldname5,fieldname7),2)

    About the fieldname12, your form does not include any fieldname12 field.

    If you want check all information collected by the forms, you simply should go to the settings page of the plugin, through the menu option: “Settings/Calculated Fields Form”, and press the “Messages” button corresponding to the form.

    Best regards.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Present Value Calculator’ is closed to new replies.