No Overload for method 'Sum'

Stimulsoft Reports.WEB discussion
Post Reply
cmcfusion
Posts: 6
Joined: Wed Jul 20, 2016 9:24 pm

No Overload for method 'Sum'

Post by cmcfusion »

I'm trying to add a Highlight condition to a field, but it's a calculation (see below) and I'm not able to get it to transfer correctly into the Condition Expression to successfully run my report.

The field I want to add a condition to uses this formula:
{SumIf(DataBand2,Details.Exp_row_per_loan,Details.Exp_row_per_loan == 1) / Details.Exp_funded_by_closer}
The field is formatted as a Percentage (as the result is a decimal).
I want to add a condition to turn text red when the result is at or above 90% (or .90). But when I enter the following as the condition expression, I receive the error "No overload for method 'Sum' takes 4 arguments"
(SumIf(DataBand2,Details.Exp_row_per_loan,Details.Exp_row_per_loan == 1) / Details.Exp_funded_by_closer) >= .90

I believe it thinks I'm trying to pass 4 parameters to the Sum method, but I'm not sure what I've formatted incorrectly.

Thanks,
Sabrina
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: No Overload for method 'Sum'

Post by Lech Kulikowski »

Hello,

To use summary functions in Conditions, Filters, Variables, etc you should use Totals.Sum() functions.

Thank you.
Post Reply