5 Replies Latest reply: Mar 23, 2016 6:26 AM by kiran ch

# sum(value) doubles values

Good Morning,

I have a Problem with my Pivot.

I have a table with all docnum related to an asset. Some docnums have more than one line (doclinenum).

he calculation "sum(valuehome)" calculated wrong. It takes in every line the amount of both lines and sums up the wrong way (1.439,30 instaed of 719,65)..

I thought of just taking valuehome instaed of sum(valuehome), but then I dont get totals.

In the pic below the total of "sum(valuehome)" is wrong and only "valuehome" does not Show a Total.

How can I solve this Problem? I want to have the correct amount in every line (719,65) and the correct sum (1.439,30).

Chris

• ###### Re: sum(value) doubles values

Divide the sum by the count of doclinenum values: sum(valuehome)/count(total <docnum> doclinenum)

• ###### Re: sum(value) doubles values

try

sum(distinct valuehome)

• ###### Re: sum(value) doubles values

I would say that you need to add a distinct to the dimension 'doclinenum' =count(distinct(doclinenum))

that way you filter out the double numbers. and the count should work properly.

(I am not entirely sure, I am not able to test it right now.)

• ###### Re: sum(value) doubles values

Hi,

Try like this

Sum(Agg(Sum(MeasureName), docnum))

Regards,

Jagan.

• ###### Re: sum(value) doubles values
Hi,  try Max rather than sum if the values are same.  Thanks Kiran Kumar