I'm trying to make a relationship to show sales of a rolling 12 months. I want to sum the Quantity field from the Invoice table, and the TotalPrice from the Invoice table in the Stock Table against the stock code record.
My original idea was to have a relationship based on:-
Stock::CurrentDate&StockCode = IF(Invoice::Date > (Get(CurrentDate)-365); CurrentDate&StockCode; "" )
Needless to say, this isn't working.
Can anyone help?
Thanks a lot