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

​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; Usage1000; 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   Read More

​