How to take summary values into calculations?

Options
vsbw
vsbw Member, ALL USERS Posts: 1 New Contributor
in Planning & Modeling

Hi i'm trying to get last fiscal year actual values but not able to take it to next year budgeting please help.Below i'm putting the logic & where i'm struggling.

Time      apr-18  may-18 aug18.......FY18-19  Apr-19     may-19       jun-19         jul-19                 Fy19-20

Actual    1000   2000       1000       4000

Budget                                                             4000/12     4000/12   4000/12     4000/12

 

Here i'm not able to get that 4000(summary of FY18-19) into next line item.

Please help.

Tagged:

Categories