It 's quite difficult to understand your expectation without seeing data structure.
Could you please create mock-up data and attach as twbx, and explain your expected view by number example.
I understand I will try putting up an example at the earliest.
Simply put I need a calculation to calculate the difference between the normal integer values and the percentage values in the table. So that I can put it to shapes for a KPI Indicator. (up and down arrows)
Currently, it is just calculating the difference between one cell and its previous value for the normal integer values.