Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers