You can perform calculations in the flexible reports using your own calculation rules in the form of report facts. You can also use formulas in the same way you would in Excel, such as:
A calculation rule could look as follows:
if [1] gt 240 then 1+([1]-240)/40*0.1 else 1
Where [1] is the report fact Total number of students.
It is also possible to refer to a specific period, for example, an academic year:
if I_I0N0D7K.LREL eq ‘Schooljaar' then [1 I_DI0N0D7K xtimerelative('I0005NCHW3', '8ROIJ7RQ33', joinchars(‘Schooljaar'), joinchars(I_DI0N0D7K), 0) else na
Where [1] is the report fact Total number of students. The last bold figure refers to a relative period 0=current academic year, -1=previous academic year, 1=next academic year, etc.
You can do the same thing for a financial year:
if I_I0N0D7K.LREL eq 'Year' then [1 I_DI0N0D7K xtimerelative('I0005NCHW3', '8ROIJ7RQ33', joinchars('Year'), joinchars(I_DI0N0D7K), 0) else na
Where [1] is the report fact Total number of students. The last bold figure refers to a relative period 0=current financial year, -1=previous financial year, 1=next financial year, etc.