• Resolved benbattaglia

    (@benbattaglia)


    I’ve been asked to update a calculator by a client.

    This calculator here: https://www.timesharecompensation.co.uk/compensation-calculator-internal/

    My current (unmodified) formula is this..
    (2*(fieldname9+fieldname11))+ (fieldname12*fieldname5)

    The client has asked me to modify my current formula so that 5% is added to the ‘Average Maintainence fees’-(fieldname12) for each year displayed in ‘Years owned’-(fieldname5).

    So please ignore the first 2 fields in the form for this.

    E.g. if the Average Fees were £100.00 it would look something like this…
    1 Year: 105.00
    2 Years: 215.25
    3 Years: 331.01
    4 Years: 452.56
    5 Years: 580.19

    Any idea what formula I could use to get this to work?

    I’ve been given a spreadsheet by them to demonstrate, but the issue is I can’t copy the calculation they’ve used as it relies on data that is present in the spreadsheet, whereas this form will need to calculate it all at once.. so i’m a little confused.

    Any help is much appreciated!

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello,

    I guess you need something similar to:

    2*(fieldname9+fieldname11)+fieldname12*fieldname5*1.05

    However, the support service does not cover the implementation of the users’ forms and formulas. If you need help implementing your project, I can offer you a custom coding service through my personal website:

    https://cff.dwbooster.com/customization

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Trouble with a calculation formula using %…’ is closed to new replies.