Select Top 2 rows where field = 2,3,4 and 5

[Cpreston]

Hi

I have made another thread as I feel my last one as become complicated than it needs to be

I have forumla that does as below for Source = 1 and Finished = 6, I want Processed to be numbered 2 to 5 (there are always just 4 processes) and then select only numbers 2 and 3 to display in my report.

If {@FormattedLineType} = 'Source' then 1
If {@FormattedLineType} = 'Process' then ??????
If {@FormattedLineType} = 'Finished' then 6

Any ideas how I achieve this please.

Thanks

 

[Cpreston]

I managed to get it working.

I did the numbering for the Type
The I did a Running Total count on only the Process which gave me the number 1,2,3,4,5
I then suppressed the Group other than 1 and 2

Long winded maybe but it worked.