Doubts about repeated rows

[#1]

Hi everybody. I have repeated values in a table, and i have problems showing them. My english leaves a lot to be desired, i´ll put an example.

Field 1 = 2070

Field 2 = 1

Field 3 = sum(field 1 - field 2)= 6207

Ok.. i guess the row is repeated 3 times and i have 2070 x 3 and 1 x 3 but i can´t see the values and if the user sees this it seems like an error. What i have to do to see the field 1 as 6210 and the field 2 as 3 ??

Thank you all

Greetings.

[JonnyPoole · Accepted solution]

Field 1:   sum(2000)

Field 2:  sum(1)

Field 3:  sum( 1999)    or  sum (2000 - 1) or  sum (2000) - sum(1)  ...  your choice

[#3]

Ok the mistake was THE SUM(1 - 2 )

Now i´ve put the fields like

SUM(FIELD1)

SUM(FIELD2)

and SUM(FIELD 1) - SUM(FIELD2)

thank you!!

[JonnyPoole]

Glad it worked .  Any followup questions ?  Just ask or please close out the thread.