1 Reply Latest reply: Aug 9, 2010 5:28 PM by Vlad Gutkovsky RSS

    Max Month only with Data

    Henry Noh

      I want a text box to return the Max(month) or latest month which has data in it.

      The problem is when I use the max (month) in always returns 12/Dec because I have loaded in a mapping table with months/dates going out to 2015.

      Is there a way of writing my expression such that Max(month) will return only the latest month for which revenues exist?

       

      Thanks in advance!