I've been trying to use LOOKUP with MINI/MAX, but I am not getting the required results.
I simply want to calculate the day difference between each row (Days Diff column) and restart the calc at each LOG ID:-
The table above is sorted by LOG ID then DATE.
- One LOG ID = 0 days diff
- Multiple LOG ID's = calculate difference of days between rows
Thanks in advance.
Your calculation has to be set as Compute using: Table Down