1. TARGIT Community
  2. Community
  3. Frontend, Designer and Consumer
Knowledge Base

Percent growth between Rows

Marcel Reinert ·

Is it possible to show the percentage change of each value based on the previous value (row)? That is, the change from week 30 to week 31, from week 31 to week 32, etc. in percent as an additional column?

 

0

Comments

2 comments
Sort by DateVotes
  • Ole Dyring

    Hi Marcel,

    Yes - that should be possible.

    Try this syntax:

    (sum(d-1, 0, m1) - sum(d-1, -1, m1, 0)) / sum(d-1, -1, m1, 1) * 100

    or

    (sum(d-1, 0, m1) - sum(d-1, -1, m1, sum(d-1, 0, m1))) / sum(d-1, -1, m1, 1) * 100

    The difference is how the first row should behave.

    BR / Ole

    1
  • Marcel Reinert

    Ok, i'm impressed. :) Works both, thanks for this!

    0
Please sign in to leave a comment.