Calculate summaries based on User Functions

HOW-TO
Add an average of calculated items in the footer section

SOLUTION
Summaries can be added on the User Functions in the same way as on data source fields. For example, if your summary function is:

    public static double CalculateOrderPrice(double unitPrice, int amount)
    {
        return (unitPrice * amount * 1.20); //with VAT :-)
    }

and your data field names are UnitPrice and Amount, you can set the following expression as the Value of a TextBox to calculate the Average of the results returned by the User Function:

=AVG(CalculateOrderPrice(UnitPrice, Amount))

Attached you can find a little project containing a report that demonstrates the above scenario.
 

Files