4 Replies Latest reply on Oct 31, 2018 2:53 PM by Deepak Rai

    calculate Latest Month

    satya kanth achanta tishan

      I need to calculate "Latest Month Units" but for that the formula is :


      IF DATEDIFF('month',DATETRUNC('month',[Order Date]),{MAX(DATETRUNC('month',[Order Date]))})=0
      THEN [Units]


      But in my source Sheet (Excel) I have Year, Month and Quarter columns I don't have Order Date.

      How can I calculate Latest Month Units ?


      Thank You