Forum Discussion
Calculated Field in Pivot
Hello!
I would like to get some help regarding a Pivot Table error I came across.
So I have the following columns given:
I would like to calculate the DIH column by a calculated field/measure. The formula should be :
- ln(In Stock)/ln(1-Withdraw Rate) = x
- ln(1864)/ln(1-0,15...) = 46
When I type it inside my Pivot Table the results are way different than they should be.
I should get a result of 46 [months] instead I get 2,83.
Now the question is how can I solve this?
Thank you a lot in advance 
KoalafiedSee attached. Replicated your example and it seems to work as you intend.
Riny_van_Eekelen Thank you a lot! Strange is that I used the exact same formula. Also in my other topic that you replied to. And somehow the results are different. Can you maybe explain me what I maybe did wrong?
Koalafied I can not say what you did wrong if I can't have a look at your file.
