Calculation problem

[mich]

I am trying to set up a layout of a toner tracking spreadsheet. As soon as I need to change a cart. I want to be able to say this:

cart #------Date---Page Count------Page Per Cart.

The way I was trying to set this up was that each time I change a cart the Page Per Cart column will change by subtracting cart 2 page per cart number from cart 1 page per cart number giving me a number of pages for each particular cartridge, then I eventually want to average them the Page Per Cart Column. I have tried to use repeating fields but that will only take the diference of the last repeated field with the new one. Any suggestions would be greatly appreciated. Thanks.

[Kurt Knippel]

quote:

---

Originally posted by Mich:

I am trying to set up a layout of a toner tracking spreadsheet. As soon as I need to change a cart. I want to be able to say this:

cart #------Date---Page Count------Page Per Cart.

The way I was trying to set this up was that each time I change a cart the Page Per Cart column will change by subtracting cart 2 page per cart number from cart 1 page per cart number giving me a number of pages for each particular cartridge, then I eventually want to average them the Page Per Cart Column. I have tried to use repeating fields but that will only take the diference of the last repeated field with the new one. Any suggestions would be greatly appreciated. Thanks.

---

Assumning that you sequentially number your carts and do not skip numbers you can setup a self relationship within the file by relating to the previous cart number.

Setup a calc field cPrevCart = Cart# - 1, this will give you the previous cart #.

Setup a self relationship called PrevCart, set it to cPrevCart = Cart#.

Now you can make the calc field PagesPerCart = PageCount - PrevCart::PageCount.