numerical change based on last record

[jajadytan]

i have a portal where i have set-up a table in which a crosstabulated total for each year is being computed (Stats).

i would like to know how to create a numerical change auto-compute field to be placed beside the fields so the user can be notified of the changes as well as the difference. concept sample is on layout "What I want to accomplish".

if my description isnt clear enough, pls look at the 'Stats' and 'What I want to accomplish' layouts in the attached fm7 file here .

thanks in advance

[comment]

Try something like this, perhaps?

sample.fp7.zip

[jajadytan]

hey this is exactly what i was looking for and all i had to do was do a 'year - 1' thing! jeez

thanks very much comment, you've been a lifesaver to me twice. so thanks again!

add:

now as homework, i'll try to keep the +/- figures from appearing in the first row.

till next! :thumbup: