I am trying to add a new calculated field to a table. I want to map in the most recent price paid for the previous year for all item numbers, so that I can calculate the monetary impact of any price increases/decreases.
i.e Item numbers current line price - Item number last price paid previous year (If no value is available for the previous year use the oldest price from the current year)
