Dear BW Experts
I've a problem with calculation accuracy using formulas in BEX.
We use BEX as a controlling instrument and there was the need to calculate "price and quantity effects on sales".
Therefore I need the simple calculated key figure "Price PLAN" that is defined as planned sales divided by planned quantity.
The keyfigure for planned sales shows 8.337,98 in value, the key figure for the planned quantity 2.116 pieces.
The value for "Price PLAN" is calculated from BEX as 3,940755249. If you let Excel calculate the "Price PLAN" the result would be 3,940444234.
There is an unpursuable difference of 0,000311015 which leads to further heavy rounding errors when using this calculated key figures in other calculations e.g. multiplying with other quantities.
How is BEX evaluating formulas ?
How can I increase accuracy in calculations ?
The key figures planned sales and planned quantity are direved from the info cube with selections.
We are using BEX Explorer Version 3.0B Patch 16.3020.16.662
Thank you very much for your support