1 2 Previous Next 15 Replies Latest reply on Oct 9, 2018 2:23 PM by NAYANA MADHEKAR

    How do I get an Average?

    NAYANA MADHEKAR

      1.PNG

      When I do Last()=0, its adding all 3 weeks, which is right. But I need an average. how do I do that? Average of the last 3 columns three?

      My Formula is :

      IF

      DATEDIFF('month',ATTR([Wk Ending Date]),ATTR(TODAY()))=0

      and

      ATTR([Wk Ending Date])<=ATTR(TODAY())

      THEN

      [Sales]

      ELSE 0

      END

       

      (Sales formula -> Sum(Gross Units)/Sum(Net units))

       

      It doesn't let me do Total compute -> Average. (The result is attached in a photo).

       

       

      Thank you !!!!

        1 2 Previous Next