userelationship

Hi mwegener       What the formula is trying to do is to look at the request date (the date an order has been requested to ship) and look two months back to the order date.    We are trying to see how accurate our forecasting is and this is the logic they want to use.   So, if there are orders with requests dates in May, we would want to look at orders with order dates in March (two months back).     However, the Orders table has a primary active relationship with the date table...using "due date".    So in essence, the date table context on the orders table, at least for this particula formula, is using the wrong date context  (due date instead of request or order date).    I am trying to get the formulas to connect to the date table each with their respective date context  (either request date or order date).   Hope that makes sense?