Hi,
I performed a table calculation and using that I got the number of cases every day. What I want is to calculate the percentage difference of cases for every day.
Sheet Name: Percentage Difference of Cases
For instance: On 2nd June the new number of cases are 20,784 but on 3rd June number of cases are 19,997. So, I want to create another field which would contain the percentage difference.
Packaged workbook attached.
4 answers
You can create a calculated field with the following:
([Daily Overal Cases]-LOOKUP([Daily Overal Cases],-1))
/
LOOKUP([Daily Overal Cases],-1)
Hope this helps. Updated workbook is attached for reference.
