COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_Navision
DATASOURCENAME,C:\GlobalCube\System\NAVISION\IQD\serv_teile\Service_Nachlass_Lohn_Auftrag.imr
TITLE,Service_Nachlass_Lohn_Auftrag.imr
BEGIN SQL
select T1."Document No_" as c1,
	   SUM(((cast_float(T1."Line Discount Amount")))) as c2
from "NAVISION"."import"."Archived_Service_Header" T2,
	"NAVISION"."import"."Archived_Service_Line" T1
where ((T2."No_" = T1."Document No_") and (T2."Client_DB" = T1."Client_DB"))
and (((((T1."Document No_" LIKE 'WAU%') and (T2."Order Date" >= TIMESTAMP '2017-01-01 00:00:00.000')) and (((cast_float(T1."Line Discount Amount"))) <> 0)) and (T1."Type" = 3)) and (T1."Document No_" <> 'WAU17422406'))
group by T1."Document No_"
order by c1 asc

END SQL
COLUMN,0,Document No
COLUMN,1,Auftrags_Discount_Lohn