Calculate and Round % Difference
A demand planner creates a forecast in a planning book that includes rows for the baseline forecast and the final forecast. He uses this macro to calculate the % difference between these two key figures and round it off to 3 digits. The macro writes the result to a third row.
For this example, please refer to macro book SDP Book 9AEXAM VIEW (SALES VIEW). Row 1 is the baseline forecast, row 2 is the final forecast, and the results row is Total forecast adjustments in %.