Skip to Content
author's profile photo Former Member
Former Member

Accuracy in calculated key figures

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Nov 22, 2005 at 01:07 PM

    Hi Stefan,

    Please look at note #708827 - "Calculation accuracy for formula variables and constants".

    Best regards,

    Eugene

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.