Formula for percentage increase

[Steven_Kryger]

I would like to have a column for the % increase each week. For example:

On February 1 there were 50 people registered.
On February 8 there were 100 people registered.

How would I do this?

[Julian_Kirkness]

Hi Brett

This isn’t really possible with a database because the order of records is not set in stone (you could sort, filter, group, delete etc). It would probably be possible to use Integromat to loop through your records and update the data periodically though - but this may be an overkill!

[Patsy_Pankey]

I want to put in the Trailing Stop for an amount as in stocks and I thought you might be able to help. $15.00 with a trailing stop of 25%. In Excel I put in: =The column*0.07. So in other words when the stock hits 25% more than I paid, which is the $15.00, I want that answer. But I can’t figure out how to do this in Airtable. Can you help?

[matt_anderson1]

You can just do this ({Current Value} - {Initial Value}) / ({Current Value} + {Initial Value})/2

and format as a percentage…

[Eriks_Reks1]

@W_Vann_Hall thanks for writing this out!

[Hendrik_Yang]

OMG! This is masterpiece! Thanks for sharing.