2 Replies Latest reply: Mar 11, 2016 2:35 PM by Digvijay Singh RSS

    YTD based on Selection for Financial Year

    Hasham Khan

      Hi All,

       

      I have a query that I cannot seem to resolve.

       

      I have a field called 'MonthYear' which has the following format 'MMM-YYYY'.

       

      I wanted to calculate the sum year-to-financial-date of revenue based on the selection in the list box.

       

      My financial year starts in July. Please note i would like to do this without the use of variables.

       

      For example if the user selects Feb-2015 from the MonthYear listbox, the calculation should sum revenue from July-2014 to Feb-2015.

       

      Thanks for you help in advance.