Return today's value - data source pushes daily cumulative total!

Hi all

I have a tricky situation that has stumped me.

XXXX

'Campaign Stats' = data pushed from DotDigital email marketing platform, appending a row for each day of activity for each campaign. The final column is a 'Lookup' for Vlookups. Please don't manipulate the data in this sheet
'DD Daily' = This is the sheet we're working on
'DD Running' = This simply shows us the data in 'Campaign Stats' resorted to match the order in 'DD Daily'

The objective - As you can see, the data from DotDigital is provided as a cumulative campaign total for each day (note that the first day for each campaign will be a much bigger increment than following days, that is expected). What we actually want is the total for each individual day's activity. You can see in columns F to H that I've got tried If but realised that this will only substract the proceeding day - what we actually want to do is substract the earliest day if the row is not itself the earlier day for that campaign. I suspect MIN might be part of the answer, but I can't figure out how.

A solution would be fantastic!!!!

Instead of directing us to a third part location, please read the yellow banner at the top on how to upload a file to this forum location.

Your file appears to be corrupted. Cannot open it.

Didn't realize it was a Google Sheets issue. I don't work in that environment. Good Luck with your project.

on sheet DD Daily, in cell F2, change the reference from "-F1" to "-G1", like this:

Please Login or Register  to view this content.

then drag down to other cells.

also, i would recommend you rename DD Daily column G, because it is not the data from Campaign Stats column G.