Dynamic calculation of last amount listed

[tiverson]

I have a file that calculates an amount from the last amount listed in the data.  The last amount will change each month when a new period begins.

How can I dynamically calculate the percentage amount?

Date          Amount            % calc

Jan 93       7.461               737.6904956    formula (Last amount listed \ Amount listed on current line - 1)

Feb 93       7.501               734.3520597

Mar 93       7.5229             732.211368

Last line of data (changes each period)

Mar 24       5515.8758

Thanks for the help!

[rzdodson · Accepted solution]

@tiverson here is one approach for you. Let me know if that's what you are looking for.

[binu_acs]

@tiverson your total amount always comes in the last row then you can use the below logic

[albert_alaluf]

Hi @tiverson 

Please let me know this works for you.