calculation with let function help

[Jalz]

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)