Need help calculating out the below.
I have a table like below:
I need to calculate the difference between each date.
Example for line 1: (18/12/17) 35.4% & (17/12/17) 37.9% = 2.5% Difference.
But then I need to do this for every report date. So compare 18th& 17th, 17th&16th, 16th&15th and so on.
Once I've got the differences, I will then build a daily average.
Can anyone please advise?
Hi Sunny, ignore my previous comment - I didn't realise there was some Unit Conversion for percentage I missed from my expression until I tested it outwith this particular project!
Thanks for your help, I had never heard of the Before / After Function before today!