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
No Overload for method 'Sum'
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: No Overload for method 'Sum'
Hello,
To use summary functions in Conditions, Filters, Variables, etc you should use Totals.Sum() functions.
Thank you.
To use summary functions in Conditions, Filters, Variables, etc you should use Totals.Sum() functions.
Thank you.