I have an Endorsement report that I am working on and I need to be able to setup code to determine what Endorsements have been set for each policy.

My report displays policies with 32 different endorsement fields and each field can have an endorsement number between 1 - 603. Each endorsement will only be listed once for each policy if at all.

Ok here is what I want to do…

For each Policy I want to SUM ENDR_NO_1 - ENDR_NO_32 and put the results in different columns titled 1 - 603. If the first policy has an endorsement of 1 I want to put a 1 in the "1" column, if not I want to put a 0 in the "1" column. If the policy has an endorsement of 2 I want to put a 1 in the "2" column and if not I want to put a 0 in the "2" column, it the policy has an endorsement of 52 I want to put a 1 in the “52” column and if not put a 0 in the “52” column etc. I am sure I could use an IF statement but I don’t want to do this 603 times. Can this be done with an Array?

The report I am viewing has been setup in another area and it being calculated in Excel. We want to make this calculation in Webfocus so that the report can be generated from my HTML page.

Clear as Mud?  If there is an easier way I am all for it, I am new to Webfocus so any help would be appreciated.

This message has been edited. Last edited by: Kerry,

yes ....clear as mud...
place an example ...try to make it a bit more simple
make a screenshot or something like that

try something like this

-SET &CNTR=0;
COMPUTE ARRAY/A600='~'||''
-REPEAT ENDARRY 32 TIMES
-SET &CNTR=&CNTR + 1;
||ENDR_NO_&CNTR.EVAL||'~'
-ENDARRY
; NOPRINT
-SET &CNTR=0;
-REPEAT ENDLOOP 603 TIMES
-SET &CNTR=&CNTR + 1;
COMPUTE ENDORSMENT_&CNTR.EVAL/I1=IF ARRAY CONTAINS '~&CNTR.EVAL~' THEN 1 ELSE 0;
-ENDLOOP