Percentage Increase of a rent amount

Forum|Forum|9 years ago
July 27, 2016
3 replies
572 views

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

This topic has been closed for replies.

Ed VNAuthor

Participating Frequently

That's absolutely brilliant and works really well.

many many thanks, sorry to be so thick!!

Ed VNAuthor

Participating Frequently

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

Community Expert

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)

try67

Community Expert

For field C use this calculation:

A * (1 + B)

For field D use this calculation:

C - A

Edit: fixed small mistake

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded