Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Need help calculating out the below.
I have a table like below:
Serial | Consum | 18/12/17 | 17/12/17 | 16/12/17 | 15/12/17 | 01/12/17 |
---|---|---|---|---|---|---|
123456AT12 | 8008AABT | 35.4% | 37.9% | 37.9% | 41.0% | 42.7% |
123456AT12 | 8007TERA | 88.1% | 89.4% | 92.1% | 93.0% | 93.0% |
45012AREG | 8000ERAN | 10.0% | 10.0% | 10.5% | 11.1% | 12.3% |
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?
Thanks
Craig
May be like this
Column(1) - Before(Column(1))
Hi Sunny,
Gave it a go but it's bringing back strange figures.
example data:
18/12/17 17/12/17
69.0% 70.0%
The result came through as 150!!
Would you be able to share a sample?
Hi Craig,
Something like this?
Regards,
David
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!
Thanks,
Thanks David! Extremely helpful!
You can check them here, if you have not already seen this