i have an Pivot table with Prices of the actuale year "Preis", Prices of previous year "Preis_Vorjahr", the % change of the Price "relative Abweichung", the costs of the goods last year "Warenkosten VJ" and the calculated value with the Price cange "Warenkosten progn.".
The total sum of the calculated new Price column gives a difference of 0,02€.
Can somebody explain it or give me an example, how to do it right?
The column "Warenkosten progn." is wrong, the correct sum of the rows is 979,57 not 979,55