Hi All,
ihave 5 columns and 50 rows per all the coluns in areport, i want to create an extra column for this report using define or COMPUTE with alternate values for each row like if the forst row having the value 01 and the second row value is 02 agaain this it will repeat like third row vale is 01 and fourth is 02 this will repeat upto end.

please let me know if anyone haave idea about this.
Thanks,

Kalyan

Try using code like this:

COMPUTE NEWCOL/I1 = IF LAST NEWCOL EQ 1 THEN 2 ELSE 1;

Thanks a lot Alan, i will try to implement this.

Alan i am trying for WebFOCUS Key Sheet and Dates Reference Book do you have any Soft Copies of the Same let me know

Thanks,
Kalyan

Kalyan

There are no softcopies of these books.
Just order at Informationbuilders and pay the 2 times $ 25 ...it's worth the money. I have bought them myself last week too.

Hi Frank,
i am ready to buy, i know these books are worth for money. the problem is i am in india i dont think so they will dispatch to india.
that's i am asking the soft copies of these Books.


Thanks,
Kalyan

I would think the company you work for should be able to order them for you. Have you asked Information Builders, since that is where you have to order the keysheet.