Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need help in creating asset's future depreciation
I'v table named 'AssetsInfo' Which contain this rows
Assets No. | Year | Month | Amount | DepValue | Dep-End-Date |
---|---|---|---|---|---|
287195 | 15 | 09 | 1890 | 15.75 | 09/30/2025 |
287195 | 16 | 11 | 500 | 4.17 | 09/30/2025 |
I need to create depreciation table by using above table .
what I think to do for loop from first row (Year-Month) to second row (Year-Mont) then from second row to Dep-end-date with given amount
the achieve table that need to create as a below
Assets No. | Year | Month | Amount | DepValue |
---|---|---|---|---|
287195 | 2015 | 10 | 1890 | 15.75 |
287195 | 2015 | 11 | 1890 | 15.75 |
.. | .. | .. | .. | .. |
287195 | 2016 | 11 | 500 | 4.17 |
.. | .. | .. | .. | .. |
287195 | 2025 | 09 | 500 | 4.17 |
Can Any one help me You will find in the attached file the qvf