Percentage Increase of a rent amount

[Ed VN]

Please can someone help me? All i want to do is a percentage increase of a rent amount, i.e

field A is the current rent amount say £600

field B is the percentage that the rent will go up by, say 1.98% (i would love to change this figure if possible with an inputted figure or drop-down list)

field C is the new rent with the increase added in this case will be £611.86

field D is the new rent - the current rent which will give me the difference in £11.86

Many thanks in advance

[try67]

For field C use this calculation:

A * (1 + B)

For field D use this calculation:

C - A

Edit: fixed small mistake

[Ed VN]

Brilliant, it works a treat. The only problem that the percentage field B wont let me put in 1.98%, i have to put in 0.0198 to get it right, is there a quick way to sort this out?

A massive thank you for your help

[try67]

That's how percentage fields work. Their values are from 0 (=0%) to 1 (=100%).

If you want a field that works with values from 0 to 100 then you can use a regular Number field, maybe with a custom Format script to add the percentage symbol.

In that case you'll need to change the first formula to:

A * (1 + B/100)

[Ed VN]

That's absolutely brilliant and works really well.

many many thanks, sorry to be so thick!!