Wrong sum after calculation

Copper Contributor

Hello!
So I would like to use a calculated field inside my Pivot Table. But somehow the formula is not respected.

I have the following columns:

 

Stock; Withdraw Rate; Usage

1000; 0,3; x

 

Somehow instead of displaying 1000*0,3=300 the table shows 700. Which means somehow the result of the formula is being deducted from the source value of 1000.

Does anyone know how to fix that?

 

Thank you

 

3 Replies

@Koalafied I'm afraid you need to show the formula you wrote for the calculated filed. How you constructed the pivot table and the underlying data. Otherwise, it's difficult to understand what's going on.

@Riny_van_Eekelen  Hope you can work with those german titles :D

@Koalafied

This is what I see when I open your file:

Riny_van_Eekelen_1-1718109934725.png

The 2.839 is the result of your formula using the sum of 6 entries for Germany, each with an average of 0.1549.... . So the LN function is using 0.929499715062794. That explains the calculated value of 2.839

 

But then I refresh the PT and get this:

Riny_van_Eekelen_0-1718109927352.png

The 'MW SR Stock End' and "Anzahl von ....." change to different numbers. Can't explain why and don't have time to dig any further. Strange though is that 'Anzahl' means Count in English but it doesn't seem to be count of anything at all. Get the same numbers when I change to 'Summe von' .Sorry, can't help you any further.