We had a requirement where the user wanted to be able to get into the tool and change his formula and also wanted the change to be reflected across all his reports. Changing the formula in each report was a lot of effort and hence not practical.
This blog talks about a 6 possible ways to handle this requirement and introduces the concept of Private Variable Columns.
