4 Replies Latest reply: Sep 20, 2012 5:10 AM by dave1982 RSS

    Max Month or Current Month

      Hi,

       

      Consider the following data

       

      Month               Value

      201204             500

      201205             750  

      201206             850

      201207             600

      201208             900

      201209             (blank)

       

      I want to show, in a text box, the value for max(Month()-1). The textbox should always show the Value 900 (for this specific set of data), even when I choose another Month. Of course when month 201210 is added the 201209 Value will be filled in, and this is at that point the Value that should be shown in the text box.

       

      How should I construct such a formula ?

       

       

      Thank you,

      David