1 Reply Latest reply on Jun 12, 2016 5:42 AM by Yuriy Fal

    Calculating 4 weeks avg for weekdays

    mitra mohapatro

      Hi All,

       

      I need to create a calculated field to find the 4 weeks Average for all weekdays, as shown in the below table.

       

      For example:suppose today is sunday then it should calculate previous 4 sunday's avg and compare that avg with today's value like wise for Monday, Tuesday ....Saturday.

      Could somebody please help me with this.