Elaborate if statement works until I add another criteria

[lizzie]

Greetings

I am in the process of adding final touches to my Scorecard: a system which marks and measures sales performance.

Before Scorecard was implemented, we incentivised sales consultants based on sales targets hit AND margin made every month.

With the addition of Scorecard, I now have to add a new criteria to the calculation which calculates the incentive value that a consultant has earned.

The below statement works perfectly until I add a line (indicated here in red) which specifies that Scorecard points earned have to be higher than or equal to "First Scorecard Value" (in this case it is 60 points)

If(

GetAsNumber(StartDate) ≥ 733042

[color:red]and

Total Scorecard Points Earned ≥ INCENTIVES::Scorecard First Target

and

MARGIN_TARGET~EmployeeID::Nett Sales Less Support ≥ INCENTIVES::First Sales Target

and

MARGIN_TARGET~EmployeeID::Nett Sales Less Support < INCENTIVES::Second Sales Target;

Case(

MARGIN_TARGET~EmployeeID::Total GP Sales Percentage ≥ INCENTIVES::First Target GP Sales Percentage and MARGIN_TARGET~EmployeeID::Total GP Sales Percentage < INCENTIVES::Second Target GP Sales Percentage;

INCENTIVES::First Sales Target First Incentive ;

MARGIN_TARGET~EmployeeID::Total GP Sales Percentage ≥INCENTIVES::Second Target GP Sales Percentage and MARGIN_TARGET~EmployeeID::Total GP Sales Percentage < INCENTIVES::Third Target GP Sales Percentage;

INCENTIVES::First Sales Target Second Incentive ;

MARGIN_TARGET~EmployeeID::Total GP Sales Percentage ≥ INCENTIVES::Third Target GP Sales Percentage ;

INCENTIVES::First Sales Target Third Incentive)

Can anyone see a blatantly obvious mistake?

Advice would be appreciated!

[David Jondreau]

What table is the Total Scorecard in?

[Colin Keefe]

and

Total Scorecard Points Earned ≥ INCENTIVES::Scorecard First Target

For starters, I'd pop this part of the statement into the Data Viewer Watch List (or a custom dialog if you don't have advanced) and see if it *ever* returns true.