i have a file that i have to read in and basicly move it to the report but there is a value field that is used for some calucations.  how can i say if row count = 2 move svalue to c2 else leave alone, so that i can use field c2 for other calulations?

 

example

row count  sdata                       svalue

1                non-htstuff              15,0000

2                 commerical stuff      10,000

3                 commerical type 1      5000

4                 commerical type 2       2000

5                 stat 64                    6000

6                 stat 64 commerical    3000

7                 stat 64 comm type 1  1000

 

so the report looks like

non-htstuff                        15,000

 

commerical stuff                 10,000

commerical type 1                5,000  50%

commerical type 2                2,000   20%

 

and same thing for stat64 set  and so on...

 

any help would be great thanks

tony