Forum Discussion
myou
Helper II
Helper IIForecasting money
Hello,
I am facing difficulty in preparing this report
I have this table with different measures
| Project1 | Remaining Balance | AVG |
| ABC | 100 | 30 |
I want to add extra columns to it where I forecast the money for 2020
| Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | |
| AVG | 30 | 30 | 30 | 10 | ||||||||
| Remaining | 100 | 70 | 40 | 10 |
Each month I am subtracting Remaining-AVG
then at the end I check if AVG<Remaining , then Remaining
1 Reply
v-chuncz-msftCommunity Support