AnsweredAssumed Answered

Recall values of past years

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


Recall values of past years


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?