Total value In query

[Former Member]

Hi,

I have this query

SELECT T0.DocNum, T0.DocType, T0.CardCode, T0.CardName, T0.DocTotal, T0.Footer FROM OINV T0

In end of the DocTotal column i need total of document total

how to do it

Regards

srinivas

[former_member204969 · Accepted solution]

You probably want something like this:

SELECT T0.DocNum, T0.DocType, T0.CardCode, 
T0.CardName, T0.DocTotal, T0.Footer 
FROM OINV T0 
Union all 
Select 0,'','','',sum(t.doctotal),'' FROM OINV T

[keith_taylor2 · Accepted solution]

This is great - can you also name the total field 'Total'

[former_member204969 · Accepted solution]

SELECT T0.DocNum, T0.DocType, T0.CardCode,
 T0.CardName, T0.DocTotal, T0.Footer 
FROM OINV T0 
Union all
Select 0,'','','Total:',sum(t.doctotal),'' From OINV t 

[former_member203638]

In order to get the amount for a range of time I did so, but I do not correct the amounts:

SELECT T0.DocNum, T0.DocType, T0.CardCode,

T0.CardName, T0.DocTotal, T0.Footer

FROM OINV T0 where t0.docdate between [%1] and [%2]

Union all

Select 0,'','','Total:',sum(t.doctotal),'' From OINV t

I would like to validate that are not converted to notes of credit. Any idea?

Best regards

[former_member204969]

It is a closed thread, you should open a new one for the new problem.

[keith_taylor2]

Thank you so very much - This is something I wanted to do for over two years and was told it was impossible.

[Former Member]

Hi

I think you may not achieve it through query. But you can get total in the query result window, by holding right mouse button and click on the column header.

Thanks

Anjan Bhowmick

New-Age Business Consultants

Bangalore, India