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.
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?