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

bex reporting

Hi

Query result for Revenue = Quantity X Price.

First few results are correct. But others are incorrect. for example:

QTY PRICE REVENUE

6 5 30.00

8 6 48.00

50 10 89.00 WRONG

100 5 36.00 WRONG

In infocube, manage -it shows all correct, but some incorrect calculations in reporting.

Pls help me

Thanks

Sunder

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Nov 18, 2005 at 04:48 AM

    Hi Sunder,

    Welcome to SDN!

    Might it be that price is nominated in different currencies?

    Best regards,

    Eugene

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2005 at 02:46 PM

    Hi Sudhir,

    Welcome to SDN.

    Based on your requirement..some of them getting correct and some of them not getting thats the reason You have to write a code on Revenue in Update Rule or In Transfer Rule.

    Hopes it may help you.

    Thanks

    Bhima

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bhima:

      Thanks for your response.

      I created ABAP routine in udate rules revenue calculations.

      RESULT = COMM_STRUCTURE-/BIC/IO_PRC * COMM_STRUCTURE-/BIC/IO_QUAN.

      Any further assistance is appreciated.

      Thank you very much.

      Sudhir.

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.