## Forum Discussion

- MarkShnier__YouQrew LegendQuickbase is not like Excel where you can just make a formula between rows, so the the complexity of the answer depends on how flexible your requirements are.

To answer your question literally, I suggest making a table of Years where the Key field is the numeric Year. Then make a relationship from there to your detail records to sum up the total sales for the Year. Then make a relationship between Years and itself. For the Related Year field change the next to [

Last Year] and change it to be a formula numeric field with a formula of

[Year]-1

That will allow you to pull last years Sales into the current year record and then you can do your calculations.

------------------------------

Mark Shnier (Your Quickbase Coach)

mark.shnier@gmail.com

------------------------------