calculation with let function help

Hi Guys,

Dont know the most efficient way of doing this however, my calculation is kinda working, but drops out if the first person doesn't meet the criteria.

Can anyone help, I would basically like the results of all the case statements - first,second, third child to display underneath.

My code is underneath, basically stops if the first record in my portal EVPup::Term of entry field has a lower value than Academic Administration::Year, although the third child or fourth could have a higher value hence I would like them displayed.

Hope that makes sense.

Many Thanks

Jalz

Let ([



sixthname = Case((PatternCount(GetNthRecord ( EVpup::Form of entry; 6 );"10")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 6 );(PatternCount(GetNthRecord ( EVpup::Form of entry; 6 );"11")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 6 );(PatternCount(GetNthRecord ( EVpup::Form of entry; 6 );"12")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 6 ));



fifthname = Case((PatternCount(GetNthRecord ( EVpup::Form of entry; 5 );"10")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 5 );(PatternCount(GetNthRecord ( EVpup::Form of entry; 5 );"11")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 5 );(PatternCount(GetNthRecord ( EVpup::Form of entry; 5 );"12")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 5 ));



fourthname = Case((PatternCount(GetNthRecord ( EVpup::Form of entry; 4 );"10")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 4 );(PatternCount(GetNthRecord ( EVpup::Form of entry; 4 );"11")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 4 );(PatternCount(GetNthRecord ( EVpup::Form of entry; 4 );"12")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 4 ));



thirdname = Case((PatternCount(GetNthRecord ( EVpup::Form of entry; 3 );"10")) and (EVpup::Term of entry > Academic Administration::Year);GetNthRecord ( EVpup::child Fname; 3 );(PatternCount(GetNthRecord ( EVpup::Form of entry; 3 );"11")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 3 );(PatternCount(GetNthRecord ( EVpup::Form of entry; 3 );"12")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 3 ));



secondname = Case((PatternCount(GetNthRecord ( EVpup::Form of entry; 2 );"10")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 2 );(PatternCount(GetNthRecord ( EVpup::Form of entry; 2 );"11")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 2 );(PatternCount(GetNthRecord ( EVpup::Form of entry; 2 );"12")) and (EVpup::Term of entry > Academic Administration::Year & "/3");GetNthRecord ( EVpup::child Fname; 2 ));



firstname = Case(

(PatternCount(EVpup::Form of entry;"10")) and (EVpup::Term of entry > Academic Administration::Year & "/3");EVpup::child Fname;

(PatternCount(EVpup::Form of entry;"11")) and (EVpup::Term of entry > Academic Administration::Year & "/3");EVpup::child Fname;

(PatternCount(EVpup::Form of entry;"12")) and (EVpup::Term of entry > Academic Administration::Year & "/3");EVpup::child Fname)

]

;

firstname & secondname & thirdname & fourthname & fifthname & sixthname)