Skip to Content
0
Former Member
Apr 24, 2007 at 10:45 PM

Stuck on a Tricky Formula

16 Views

Post Author: bh1

CA Forum: Formula

Sales Team

Team Leader Bert

Assistant Target

1 Target2 Achieved CalculatedField

1 1 0 0 0

2 1 0 0 0

3 1 0 0 0

4 1 1 1 1

5 1 0 0 1

6 1 0 0 1

7 1 1 1 1

Sales Team

Team Leader

Assistant Target

1 Target2 Achieved CalculatedField

8 1 0 0 0

9 1 0 0 0

10 0 0 0 0

11 0 1 1 0

12 1 1 1 1

13 1 0 0 1

15 1 1 1 1

This query is with regards to helping me create a table to

suppress a group header.

This report is grouped by Team, Team Leader and Sales

Assistants. The report displays Target 1

and Target 2- if achieved then a 1 else 0.

If both achieved then the Achieved column =1 else 0. I would like to create another column (ie.

CalculatedField) that scrolls through each record, I want the value to be

initially 0 but as soon as soon as it comes to Achieved =1 then set the value

to 1. I would then want the value to

continue to stay at 1 for that Team Leader.

Can anyone help?