I need to fill in the Ending Balance of each Year / Period where it is 0 (zero) but a previous period for that year and company has an ending balance - basically carrying forward the ending balance for that company for the year.

This may be less complicated that I makiang it to be , but I can get my TEMP table all the way down to this, but need an update statement

reviewing the attached below

(In Yellow) Company 400 - Period 01 has an ending balance of -35460601.79, this needs to be that beginning balance of company 400 - Period 02 and then that Period 02 beginning balance is to set as the Period 02 Ending balance - then moving down through Company 400 until you get to a new Company/Fiscalyear.

Company 401 is good and no action is required

Company 500 needs to do what Company 400 did but Company 500 starts at Period 04/05 - filling down until it reaches the next company. This will process will step the entire table By Year / By Company I really appreciate your expertise in helping me Stephen

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.