How to add the difference between two columns in table

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

3 Likes