How to add the difference between two columns in table

[avid_learner]

Hi,

How do I add the difference between two columns in terms of % to a table.

For example, if I have the table above, I would like to show the difference in % between the ‘ada_cf’ column relative to ‘p_prog’ in terms of the total and also ‘ada’ column relative to ‘p_prog’ column. In this case the figure should show (9.81-7.55)/9.81 * 100 = 23.04%.

Do I have to create a new table for this or can I add it to the existing table as a new row under ‘Average’

[Brett]

Hi @avid_learner,
You can just create a new calculated field for percent difference and then add that to your current table as an additional field.

((sum({p_prog}) - sum({ada_cf})) / sum({p_prog}))

Instead of adding in the ‘*100’ to your formula, you can just format the number to be a percentage:

Let me know if this works for your case or if you have any additional questions

[avid_learner]

Hi @Brett, thanks that works for me.

I do have another issue that has been open for a while already. Not sure if you can help with that as well. It is linked here.