Displaying a formula

[mdj3366]

Hi there –

Using CR11, SQL database..I have a report that returns data as listed below:

09/03/2010 0.00 0.00 673.60 Paid
09/10/2010 0.00 0.00 673.60 Paid
09/17/2010 0.00 0.00 673.60 Paid
09/24/2010 0.00 0.00 673.60 Paid
10/01/2010 0.00 0.00 673.60 Paid
10/08/2010 1922.23 692.62 1229.61 Ineligible
10/15/2010 1922.23 692.62 1229.61 Ineligible
10/22/2010 1922.23 692.62 1229.61 Ineligible
Re-employment Bonus
10/08/2010 0.00 1,872.95 0.00 Paid
Column 3 is a formula. As you can see, 692.62 *3 is not 1872.95. Is there a way that I can get the first ineligible payment to display 692.61 so that when you add down it equals 1872.95?

Thank you.

 

[lbass]

3 X 692.61 = 2077.83

-LB