Forum Discussion
Compare Forecast Version
Hello, Every month we release a new revised forecast for our sales person to populate forward forecast numbers. I have another table which actual sales come through. When sales actualise, I need ...
Hi ttcalendar ,
I am confused about what your table looks like. Is Actual data and Forecast data in different tables like my sample or in the same table?
Your calculation is based on your data model. Please share a sample file with me.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Apologies, the actuals and forecasta data are in different tables like yours. Attached is a sample.