4 Replies Latest reply on Apr 12, 2011 4:43 AM by Mitch

    Recall values of past years

    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?