6 Replies Latest reply: Sep 24, 2014 9:29 AM by Gysbert Wassenaar

Calculate price variation

Hi I need to do something very simple, I have to calculate a price variation during the year..

I have:

price1

price2

price3

price4

price5

price6

price7

And I want: (price2-price1)/price1

..(price3-price2)/price2....

(price4-price3)/price3 and so on....

How can I do that in a table? I tried to to the ratio but It doesn't show any value!

• Re: Calculate price variation

Are those different fields in a table or values in one field? If they are values in one field you can try using the above() function. For example with a table that contains a Date field and a Price field you could create a straight table with Date as dimension and use Price/above(Price) - 1 as expression.

• Re: Calculate price variation

Are different field in a table

• Re: Calculate price variation

Then you need a different expression for each variation calculation:

Expression1: Price2/Price1 -1

Expression2: Price3/Price2 -1

...etc

• Re: Calculate price variation

I'm trying to do that but It doesn't shows any value just an hyphen!

• Re: Calculate price variation

Can you post an example document that demonstrates the problem?

• Re: Calculate price variation

Does the following script give a clue to solve your problem?

Data:

LOAD RowNo() as ID, * Inline [

Price

10

11

12

13

14

15

13

11

];

Final:

NoConcatenate