CleverQ gives you the capability beyond simple regression analysis. CleverQ has built in Trend functions at that formula level so you can calculate metrics using forecasted data. CleverQ's functions give you the choice to use the raw forecasted data, best fit forecasting based on the R squared value, Seasonally adjusted trend, or a combination of all of the above. You can now use forecasted data nested in your formulas to provide you with the tools to calculate nearly any forecasted business metric imagionable. You can even apply other functions to your formulas. The red Line in the graph above is applying a quarterly moving average to target Inventory which is based on seasonally adjusted forecasted Cost of Goods and desired turn over. CleverQ is doing all of the calculating from raw data of only the Cost of Goods. This is a exclusive CleverQ feature not possible in competitions calculated fields or columns.