1 Reply Latest reply on Oct 23, 2012 6:49 AM by Darren Evans

    How to get current month as a numeric?

    Ajit Kumar

      I am creating a formula something like this –


      ((98-Profit %) /3)* Number of current months ?


      I am not able to understand what should be the formula for getting Numeric value of Number of month. Example if the current month is October then 10 should come there, if March is the current month then 3 should come there.


      Please help me on this.

        • 1. Re: How to get current month as a numeric?
          Darren Evans

          Hi Ajit


          By current month do you mean todays date if so try




          You may need to average this if you have multiple lines of data and/or your Profit % is pre aggregated




          Or is current month the month on the row of data. if so try something like


          datepart('month',[YOUR DATEFIELD])