Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sum problem!!

Status
Not open for further replies.

bowsermxli

Programmer
Aug 27, 2002
9
MX
i am getting 0 in my compute Column Sum(inSumary Band) when a retrieve the dw, any idea?

i need count when Source=1, count when source=2 and count when source=3

******DATAWINDOW ***********
----------------------------
(Group)Id=1000 Source=2
----------------------------
(Detail)Data=x RowCount=2 (ifSource=2,1/RowCount=1/2,0)OK
(Detail)Data=y RowCount=2 (ifSource=2,1/RowCount=1/2,0)OK
-----------------------------
----------------------------
(Group)Id=1001 Source=3
----------------------------
(Detail)Data=a RowCount=2 (ifSource=2,1/RowCount=1/2,0)Ok
(Detail)Data=b RowCount=2 (ifSource=2,1/RowCount=1/2,0)Ok
-----------------------------
----------------------------
(Group)Id=1002 Source=1
----------------------------
(Detail)Data=b RowCount=2 (ifSource=2,1/RowCount=1/1,0)Ok
-----------------------------
---sumary--------------------
Count(id for all distinct)=3 (ok)
Sum(Compute) = 0 (wrong)
------------------------------
Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top