Skip to Content
0
Former Member
Mar 18, 2008 at 02:13 PM

Customization of a Query

29 Views

Dear Experts,

my requirment is to know the evolution(stock) from month to month.

for example(for more explanation)

need to calculate opening stock of current month from closing stock of previous month.

i.e.(current month opening stock = previous month closing stock)

and evolution stock result will be calculated as

Difference between the « closing stock of Feb » – « the closing of Jan » =evol result

The idea is to build a query that can deliver the results immediately.

report shoulb execute like this....

Calander year/month | Closing stock | Opening stock | Evolution

JAN 2000----

-


| 100 | NOVALUE(BLANK) |NOVALUE(BLANK)

FEB 2000----


| 150----


| 100----

-


| 50

MAR 2000----


| 170----


| 150----

-


| 20

For sure, the challenge is to see the « Closing period of January », reported as ‘OPENING’ in the row of February.

Could you analyze this request, as Bex query

@The user should have the possibility to choose the periods he wants (variable – interval – mandatory).

Trying with cell definition and vertual key figure.please advice furher.

alternative are welcome.

Thanks in advance.

Edited by: S MB on Mar 18, 2008 3:13 PM

Edited by: S MB on Mar 18, 2008 3:19 PM

Edited by: S MB on Mar 18, 2008 3:20 PM

Edited by: S MB on Mar 18, 2008 3:21 PM

Edited by: S MB on Mar 18, 2008 3:23 PM