BusinessObjects Board

Issue with SUM

building reports webintelligence
#1

CaseTable(ID,Refund)----PerformanceTable(ID,Amount)
—ID—Refund-----------------ID—Amount
—A-----30-----------------------A—100
—B-----50-----------------------A—150
—C-----100----------------------A—250
(Sum(Refund)=180)------------B—300
------------------------------------B—200
------------------------------------B—100
------------------------------------C—120
------------------------------------C—150
------------------------------------C—400

Two tables are joined on ID in Universe

and when I drag the three column in webi this is what i see. If i do a sum on refund it is wrong because it should be 180 and not 540.
ID Refund Amount
A—30-----100
A—30-----150
A—30-----250
B—50-----300
B—50-----200
B—50-----100
C—100----120
C—100----150
C—100----400

Sum(Refund)=540

How can i get the sum of Refund as 180 in webi …??

mminhajm (BOB member since 2009-03-06)

#2

I cannot really decipher your proposed table structure, but look for keywords: chasm trap or fan trap and how to resolve those.

Andreas :de: (BOB member since 2002-06-20)

#3

Hi,

What you are experiencing is called a fan trap (as Andreas mentioned above). Here is Designer’s FAQ how to solve the problem:

Marek Chladny :slovakia: (BOB member since 2003-11-27)