Date: Thu, 28 Mar 2024 15:38:07 +0000 (UTC) Message-ID: <239027524.3978.1711640287512@localhost> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_3977_1333123506.1711640287511" ------=_Part_3977_1333123506.1711640287511 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
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 financ= ial year. This can tell you how the total payments average trend changes du= ring the year.
Changes might be necessary when adding drill-down.
def y = =3D dateYear(); def m =3D dateMonth(); def result; def int monthTotal; monthTotal =3D m + ((y-2011)*12) - 6; // eg. FY starts in July 2011 result =3D cumulateFromDate('2011-07-01','M_INDICATOR') / monthTotal; return result;
You can observe result of the applied formula in the following chart.