cancel
Showing results for 
Search instead for 
Did you mean: 

Compare value with previous period

Former Member
0 Kudos

Dear experts,

How to create need report compare price in comparison in previous period (previous row).

Example.

Row. Date

Columns: price, % trend in prices (increase/reduction]

29.04.2003 182,00 EUR/T

24.06.2003 165,55 EUR/T 9,3-

25.07.2003 146,30 EUR/T 9,9-

01.09.2003 145,00 EUR/T 0,1

26.09.2003 145,00 EUR/T 1,8-

Thanks

Tom

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi Srini,

thanks for answer, but there are not period(month), there are days in the report and those days does not as a day by day. I thing there is not possible to use offset -1.

Thanks Tom

Former Member
0 Kudos

Hi, is possible to create type of this report in Business Objects. Tom

Former Member
0 Kudos

Hi Tomas,

Even you can create same in BEx..

First Calculate average Price for each period.

Then use these avg price data to create difference with formula(Current month price - Previous month price).

As we can do SQL coding and group by in BO, its very easy in BO.

Hope it Helps

Srini

Former Member
0 Kudos

Hello Experts, could you help me?. Thanks. Tom

Former Member
0 Kudos

Hello, does anybody know, how to do it?

Tom

Former Member
0 Kudos

Thanks for quick replay.

Maybe is possible to do it as a cell definition. The query comes from IC 0PUR_C01. The KF price is created as a calculated KF. This price is price for purchase order. We need compare price from those orders sorting by day. It means how the price of pur.order is changing in percent value. The pur.order is joint with day, but we want to see it as a AVG price also per monthly period. If you need some of screen I can send it you by e-mail.

Thanks

Tom

former_member188325
Active Contributor
0 Kudos

it may be possible with Cell definition.But depends on Query design.pl let us know the design of your query.