2 Replies Latest reply on Sep 26, 2016 3:05 PM by margaret.quigley

# Quick Table Calculation - Difference; is there a table calculation that will include the difference between 0 and the first row in the table?  Hello,

I'm using the quick table calculation "Difference" to show the difference in views of an online video from one hour to the next. I see that this quick calculation doesn't show the difference between 0 and the first row collected (the difference between 0 and 120813). The first data point is just the difference between the first row collected and the second, so 145813. Is there a way to edit this calculation to additionally plot the difference between 0 and the first point? The calc comes out to: ZN(SUM([Org3Views])) - LOOKUP(ZN(SUM([Org3Views])), -1). I'm doing this for hundreds of videos.

Here's an example of a column I'm working with (in reverse order) for one video:

Org3 Views

1317417

1260150

1207274

1143502

1071132

1000247

922548

843725

767716

694327

628383

554846

471191

382025

266626

120813

Thanks!

Margaret

• ###### 1. Re: Quick Table Calculation - Difference; is there a table calculation that will include the difference between 0 and the first row in the table?

Just wrap the second term in your formula in another ZN(). Thus:

ZN(SUM([Org3Views])) - ZN(LOOKUP(ZN(SUM([Org3Views])), -1))

• ###### 2. Re: Quick Table Calculation - Difference; is there a table calculation that will include the difference between 0 and the first row in the table?

Thank you!