5 Replies Latest reply: Mar 23, 2016 6:26 AM by AC BC RSS

    sum(value) doubles values

    Christian Wylezol

      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).

       

      Thanks in advance.

      Chris