Skip to Content
0
Former Member
Jul 04, 2006 at 01:47 PM

Display Result Row in Query

30 Views

Hi Gurus

I need to Display Result Row in Query

story is like This

<u>Report 1 with <b>Calculate Result as</b> Nothing Defined</u>

Product-- A B --C = ABS(B-A)

-


P01--


10-00---10

P02--


00-50---50

P03--


10-40---30

-


Result-- -20 -90---<b>70</b>

-


Over all result of C = ABS((Over all result of B) - (Over all result of A))

i.e in above Example <b>70</b> = ABS(90-20)

<u>Report 2 with <b>Calculate Result as</b> Summation</u>

Product-- A B --C = ABS(B-A)

-


P01--


10-00---10

P02--


00-50---50

P03--


10-40---30

-


Result-- -20 -90---<b>90</b>

-


The Above result is displayed if the Properties of C is set to Summation from <b>Calculate Result as</b>

My requirment here is

Without using Product in Query i want the only over all result in Query output as <b>Calculate Result as</b> Summation

20 90 <b>90</b>