Skip to Content
0

How to calculate a value based on previous date in a crosstab

Jul 19, 2017 at 07:47 AM

22

avatar image

Hello all,

I have the following crosstab based on Bex Query (and Composite in the backend):

in the Delta% field I need to calculate the difference between Value B of the current date and the Value B of the previous date (the dates are not consecutive), divided by Value B of previous date. In short words (F-J)/J.

The above formula returns correct values only for the first column. The second column formula is automatically filled with (J4-J4)/J4, the next one is (N4-J4)/J4 and so on.

Can you please give me a hint on how I can solve this?

Thanks in advance,

Best regards,

Andreea D.

untitled.png (47.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers