Hi,
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
Hi
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.
Cheers
Jake