Calculating difference between columns

I have a table as shown below. I want to know to calculate the column Total-Partial1, Total-Partial2 since the two columns that I am calculating difference for are not next to each other.

Hi Ankit,

would 2 calculated fields be sufficient? One “Total-Partial1 = Total - Partial1” and the other “Total-Partials2 = Total - Partial2”.

And would you clarify a bit on why columns not next to each other will create an issue in this context? Thanks

1 Like


You’d create 2 new calculated fields.

The first calculated field would be "Total - Partial1’ and the second calculated field would be “Total - Partial2”. This should work regardless of whether the columns are next to each other unless you have date fields in the table.

Hopefully I was some help.