AnsweredAssumed Answered

Recall values of past years

Question asked by Mitch on Apr 2, 2011
Latest reply on Apr 12, 2011 by Mitch

Title

Recall values of past years

Post

Hi All,

I have a database that allows for the input of data relating to the 'Minimum Cost' and 'Maximum Cost' of items each year, in the foirm of a portal.  I am now interested in creating a graph that displays both these values, but only recalls the last five years value from the current year, or five years from a year specified on another field.

I obviously have to create an number of calculation fields, one each for the minimum and maximum value for each year 1 through to 5, but does any one have any idea of the calculation to recall to the data? 

Outcomes