It is recommended to get familiar with cumulateFromDate function before proceeding with this tutorial.

The result of this tutorial will be the cumulated value of an indicator (eg. payments) divided by number of months from the beginning of the financial year. This can tell you how the total payments average trend changes during the year.

Changes might be necessary when adding drill-down.

def y = dateYear();
def m = dateMonth();
def result;
def int monthTotal;

monthTotal = m + ((y-2011)*12) - 6; // eg. FY starts in July 2011
result = cumulateFromDate('2011-07-01','M_INDICATOR') / monthTotal;

return result;

You can observe result of the applied formula in the following chart.

cumulatefrom

Next Steps