Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Field 1: sum(2000)
Field 2: sum(1)
Field 3: sum( 1999) or sum (2000 - 1) or sum (2000) - sum(1) ... your choice
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!!
Glad it worked . Any followup questions ? Just ask or please close out the thread.