Mulitple field comparison

[Roscoe307]

I have a long list of request numbers that are tied to contract numbers. Some of request numbers can be tied to multiple contract numbers. I need to find where this is true and then add the dollar amounts associated with those contracts together. This might be really simple and I'm just over thinking it.

I'm using CR XI and an oracle db.

Thanks for the help!

 

[lbass]

Insert a group on request number and then a second group on contract. Then insert summaries at the group #1 level.

If you want to isolate those with multiple contracts, use a group selection formula like:

distinctcount({table.contract},{table.requestnumber}) > 1

-LB

 

[Roscoe307]

Am I inserting the summaries(='AMT1')and the request number group(group #1)?

Also, (sorry these requirements are coming in as we speak) I need to take that dollar amount 'AMT1' (where the request is associated to multiple awards) and compare that to another dollar amount 'AMT2' that is associated with the same request and award numbers. Then I only want to display those where 'AMT2'>'AMT1'.

Thanks so much!!

 

[lbass]

I don't know what you mean by amt1 and amt2. Why don't you insert a group on request number and then put the contract and amount fields in the detail section. Insert summaries on each amount field. Then show a sample of the results from this and explain what the comparison is--is it a comparison of a summary of these fields at the request level?

-LB