Forum Discussion
Calculate projection
Hi, please for the following sample data, is it possible to calculate the cell's prevision by using the Month column as filter? I'm not sure whether it is possible or not. I want to calculate t...
Hi,
please for the following sample data, is it possible to calculate the cell's prevision by using the Month column as filter?
I'm not sure whether it is possible or not.
I want to calculate the cell's prevision of June, July and august (where the data are missing in the column "Cell")
For a selected period (for example from Feb. to June) in the filter (the column Month),
the cell's prevision of June = [SUM(Cell)/SUM(Objective "where Cell is not null")]*(Objective of June)
Cell | Objective | Month | Year |
5000 | 5500 | 1 | 2018 |
2546 | 3000 | 2 | 2018 |
3265 | 3000 | 3 | 2018 |
4587 | 4300 | 4 | 2018 |
1254 | 2000 | 5 | 2018 |
| 5600 | 6 | 2018 |
| 5200 | 7 | 2018 |
| 6000 | 8 | 2018 |
May I kindly ask for your help?
Thank you