How to calculate avg of values between two dates

Hi Prangya,

You can try using an IF statement to code whether a date is less than "day 15".

          SUM( IF [DATE] <= [DAY 15] (insert your calculation for day 15)

          THEN [PV]

          ELSE 0

          END)

Hope it helps!

Wannie