Skip to Content
Former Member
Dec 19, 2006 at 04:56 PM

FOX formula & time period?


Hi all,

I have one IO- closing marker to mark all closing period for transaction data. I found that my FOX formula calculate two periods (closing period & opening period) seperately.

For example:

Closing period: 1-10

Openning period: 11-12

The formula is <u>Equipment values$ ( begining balance) = previous period balance (ending balance) ;</u> and the<u> current period ending balance = current value$ + previous period balance</u>.

So I cannot get the begining balance from period 10. Any suggestion?

Thank you.