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
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 Read More