0 Replies Latest reply: Mar 23, 2012 3:10 AM by Nikita Chumakov RSS

    Get last month of the selected year containing non-blank values

    Nikita Chumakov

      Dear gurus,

       

      I am developing the report in which I need to sort the distributors in descending order by the stock QTY at last month within the selected year. If selected year is history, then Month should be 12, if 2012 is selected, then Month should be 2 as last month stock was reported is February. Could you please elp with the formula?

       

      Thank you in advance.