AnsweredAssumed Answered

Dynamic Relationship

Question asked by PeterEvans on Jun 11, 2012
Latest reply on Jun 11, 2012 by PeterEvans

Hello All


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