Forum Discussion
Combine weeks data and variance
Hi
A have a large data file that contains actual and forecast numbers which is labelled week 0, then to get each version of the forecast we combine week 0 and the relevant forecast weeks adjustments, for example week 44 is week 44's adjustments and week 0.
Is there a method to combine the same data in the list so I can pick week 44 and it will combine those, or if I pick week 43, it adds up the prior weeks forecast?
Then additionally is there a way to do a variance between each week?
Thank you
Rob
1 Reply
rdsclark ,
A have a large data file that contains actual and forecast numbers which is labelled week 0, then to get each version of the forecast we combine week 0 and the relevant forecast weeks adjustments, for example week 44 is week 44's adjustments and week 0.
Is there a method to combine the same data in the list so I can pick week 44 and it will combine those, or if I pick week 43, it adds up the prior weeks forecast?
I'm confused on your description. Could you clarify more details about your requirement and share the sample data?
Regards,
Jimmy Tao
