4 Replies Latest reply on Oct 31, 2018 4:41 PM by Shinichiro Murakami

    Latest Month Units

    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]
      END

       

      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