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

           

          datepart('month',Now())

           

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

           

          avg(datepart('month',Now()))

           

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

           

          datepart('month',[YOUR DATEFIELD])

           

          Darren