Count in Roster

[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!!

[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.

[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.