Multiple Equations

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

    (@codepeople)

    10 years, 2 months ago

    Hi,

    If the “Sales Price” is the fieldname1 field, the “Interest Rate” is the fieldname2 field, the equation associated to the calculated field would be:

    fieldname1-fieldname1*fieldname2-4500-0.25*fieldname1

    or even simpler:

    (0.75-fieldname2)*fieldname1-4500

    Best regards.

    Thread Starter kkmarch7

    (@kkmarch7)

    10 years, 2 months ago

    Hi thank you for your response I added the following to the set equation and the number is still incorrect.

    PREC(fieldname3-fieldname3*fieldname6-4,500-0.025*fieldname3,2)

    Fieldname3 = 200,000
    Fieldname6 = .533

    200,000 – 200,000 x .533 – 4,500 – 0.025 x 200,000 = 102,900

    For some reason I keep getting 93,396. Am I supposed to put additional parentheses somewhere?

    Plugin Author codepeople

    (@codepeople)

    10 years, 2 months ago

    Hi,

    Please, removes the thousands separator symbol from the numbers in the equation:

    PREC(fieldname3-fieldname3*fieldname6-4500-0.025*fieldname3,2)

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Multiple Equations’ is closed to new replies.