10 Replies Latest reply on Sep 28, 2015 11:27 PM by JayC

    Using Previous Month Figures in calculated field

    JayC

      Hi,

       

      I would like to fetch previous month number in my case Aug'15 for a particular metric say for sales from an existing worksheet and use that particular figure in calculated field.

       

      Note: number is dynamic and changes as per filter

      Have tried below-

      DATE(DATEADD('month',-1,TODAY()))

      OR

      DATE(DATETRUNC('month',DATEADD('month',-1,TODAY())))

      But has not worked.

       

      Is there a way to achieve this?