Calculating in rows

Hello everybody,

 

I have a data view with turnover, the order Backlog and the sum of both for every day:

 

 

Now i want to calculate the differennce from one day to the other in a separate column like this:

 

 

Are there any Nexel formulas for this?

 

Thank you in advance

Answers

  • Nicolas CHIGROS
    Nicolas CHIGROS Active Partner
    Fourth Anniversary 250 Up Votes 25 Likes 10 Comments
    edited March 2020

    Is Nexel necessary to you?

    Because otherwise, you can add block(s) and use a Period Offset -1 in your layout. then do the difference.

    image

     

    PS: It's doable in Nexel, just not worth the hassle I think.

     

    Regards,

    Nicolas