Hello. I'm trying to find a solution to calculate daily productivity by taking the difference between the sum of today's (latest data input) value and the sum of yesterday's (or last data input value). Can someone assist?
For example, if the sum of a column for today (latest data input date) = 25 and the sum of a column for yesterday (previous data input date) = 10. Then, my productivity for today = 15.