How to get the average of a previous month in the current month ?



I have a grid where in I need to calculate the average of the commissions selected for a couple of months  and then  to send it to another grid of a different month. How do I do it ?
PFA screenshots
Need help urgently

Thank you 

Best Answer

  • JaredDolich


    Yep use TIMESUM, not CUMULATE and only sum on the months you want, presumably the last three months. Use a dimensionless module to calculate the last three months so you aren't hard-coding. You've almost got this!