Selecting & modifying groups based on 1st group data


#1

I’m constructing a procedure to modify some fields and I think my best way to approach this is to be able to identify a cell in the first record of a group (after a Group Up). So basically I think I want:
Group Up
Select all groups where a particular cell (call it Score) in the first record is < 80
Sequence "2 1"
Then move on to the next group until all groups are dealt with

Thanks in advance,
Leo


#2

The best procedure I can think of is the one I suggested on the QNA. See my response at http://provue.com/pipermail/qna/2016-May/018764.html

Dave


#3

I never saw that response Dave, thanks! I’ll work on that idea and let you know how it works.

Leo


#4

Thanks for the help. I incorporated your routine with mine and it all works perfectly. If anyone is curious this is the section of the procedure that deals with this problem:

;change first places <80 to 2nd
; field combo is the temporary field
Field combo
FormulaFill ?(Place=1,?(Total < 80,"","#"),"")
Propagate
Select «» = "
"
Field "Class"
GroupUp
ColumnHelper
Field "Place"
Sequence "2 1"
RemoveSummaries “7”
;do not allow any places greater than 3
FormulaFill ?(Place>3,zeroblank(0),Place)
First record
SelectAll