I need a query to get the YTD depreciation for a register which includes assets fully depreciated in

Summary:

I'm getting all the assets which depreciated in the period selected, but if an asset if fully reserved in a prior period of the same fiscal year, it gives a ytd depreciation of 0.

the reuqirment is within that year it shows same the max dep perod value and in next fiscal year it shows zero

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):