Page 1 of 1

Count in Roster

Posted: January 24th, 2014, 8:26 am
by lezixb
Hi everybody,
I'm Alex and i am working on a CSpro interface. I am working on a roster table which has 20 colomns and 12 rows. the first column takes the total number of tick within the current row.i want to set a validation so that the number of tick within a row is the same as that of the total .
Please is a Roster,

diagrammatically: hope u get the picture

total |column1| column2 ...20
1. cell |cell |cell...
2. cell |cell |cell...
. .
. .
12 . .
i want to write a code that will count the number of tick cells so that it doesn't exceed the total. can anyone help me
thanks!!

Re: Count in Roster

Posted: January 25th, 2014, 7:08 am
by khurshid.arshad
Hi Alex,

Your question is not clear. If you can create this roster in excel and share on this forum and hopefully i can help you.
a.

Re: Count in Roster

Posted: February 18th, 2014, 11:16 pm
by Gregory Martin
Are you trying to use the first column as an indication of how many columns should be filled out for the given row? If so, see attached for a way that you could do this. It requires a little programming. For example:
function endGroupIfCountMet(columnNum)

    
if columnNum > CONTROL_COLUMN then
        
skip to next CONTROL_COLUMN;
    
endif;

end;


PROC COLUMN_01

preproc

    endGroupIfCountMet(
1);


PROC COLUMN_02

preproc

    endGroupIfCountMet(
2);

// etc.