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

Can we use Cumulated values in further calculations in BEx

Posted on Jan 04, 2008 at 07:03 AM 33 Views

Hi All,

We are using BEx Query Designer to create a query having one formula variable “Stock on Hand” as a cumulated value (along the columns).

Now we need to use this cumulated value in another formula variable. Is this possible to do? If not could you please suggest an alternate for the same?

Stock on hand (for any given week) = (Total Receipts – Total Demand) + Stock on Hand (for previous week).

Inv. Carrying Cost (for any given week) = Stock on hand (cumulated values as above) * per unit inv. cost

Data for Total Receipts, Total Demand and Per unit Inv. Cost is present in the infocube at daily level. A sample report template has been given below:

Week W1 W2 W3

Total Demand 10 10 25

Total Receipts 20 0 15

Stock on Hand 10 0 -10

Per unit Inv. Cost 2 2 2

Inv. Carrying cost 20 0 -20

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2008 at 11:15 PM
    1

    Hi

    I think formule can contain either the cumulative or another formula also.

    try it out. Good luck.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 05, 2008 at 02:32 PM
    1

    hi,,

    yes you can use cumulated values.. if you have this field as a separate column in the structure, then u can use it in the formula any time..

    Regards,

    Shakeel.

    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.