Case fill in percentage
Posted: March 8th, 2019, 1:11 pm
Dear all,
I'm thinking about a way to have which percent of each case has been filled. For roster by exemple, before entering, i would have an item who're stored the expected occurrence (rows) to be filled.
My first idea is:
1. To have a metadata table (maybe in Cslog) having Dictionary macro as metadata in two related table having:
1.1) Table_1(simple record)
postproc of the Roster.
3. Finally select count where Item_fill =0 or 1 or 99 for having final results.
But, until now, i can't find a way to have dictionary macro as a table...
Waiting for your help for any corrections or better idea.
Thanks in advance,
I'm thinking about a way to have which percent of each case has been filled. For roster by exemple, before entering, i would have an item who're stored the expected occurrence (rows) to be filled.
My first idea is:
1. To have a metadata table (maybe in Cslog) having Dictionary macro as metadata in two related table having:
1.1) Table_1(simple record)
- a.- Record_name;
b.- Item_name
c.- Item_type (alpha, numeric,date);
d.- Item_size;
e.- Item_fill (0:if not fill or 1:if is filled or 99: if skipped);
f.- ID_items (where ID items are stored)
- a.- Occurrence_number
b.- Record_name;
c.- Item_name
d.- Item_type (alpha, numeric,date);
e.- Item_size;
f.- Item_fill (0:if not fill or 1:if is filled or 99: if skipped);
g.- ID_items (where ID items are stored)
postproc of the Roster.
3. Finally select count where Item_fill =0 or 1 or 99 for having final results.
But, until now, i can't find a way to have dictionary macro as a table...
Waiting for your help for any corrections or better idea.
Thanks in advance,