using Column AVG and custom function

[Tim]

I use the below custom function to convert the numeric value in my Risk column to its text equivalent.

= ReturnRiskLeveltext(Fields.RiskLevel)

public static string ReturnRiskLeveltext(int rId)
{
    using (DataEntities ctx = new DataEntities())
    {
        var RiskLevel = ctx.RiskLevels.Where(x => x.RiskLevelID == rId).SingleOrDefault();
        return RiskLevel.Level;
    }
}

However, in the footer row I wish to display an Average Risk Level

= Avg(Fields.RiskLevel)

Would be correct because it returns a 2. however, I wish to again display the Text equivalent.

= ReturnRiskLeveltext(Avg(Fields.RiskLevel))

Throws an error 'An error has occurred while processing TextBox 'textBox11': The expression contains undefined function call ReturnRiskLeveltext().'

Ideas?

[Steve]

Hello Tim,

The return type of the average aggregate is determined by the type of the evaluated result of expression. So if it returns type different than int specified as argument type of your user function, it would throw this error. You can change it to object and use appropriate cast in the user function directly or debug to determine the proper type and change the type of the argument.

Greetings,
Steve
the Telerik team

[Tim]

I got this working with a simple CAST

= ReturnRiskLeveltext(CInt(Avg(Fields.RiskLevel)))