Summary fields - adding one column and subtracting a second column

Melanie Sanders

Hi All,

I have been trying to get a simple formula to work and I am having issues. Maybe it is just my brain but would appreciate some help.

I have added and removed SUM after the = and neither work

=([VENDOR QUESTION Amount of Credit]:[VENDOR QUESTION Amount of Credit]) - ([AP QUESTION Amt $ Posted]:[AP QUESTION Amt $ Posted]) and when I hit enter I get #INVALID OPERATION.

Thank you!

John Jonassen

You actually needed to add another SUM to the mix...after your subtraction sign. So, Sum the Vendor Question Amount Credit, minus the Sum of the AP Question Amount $ Posted. It should look like this:

=SUM([VENDOR QUESTION Amount of Credit]:[VENDOR QUESTION Amount of Credit]) - SUM([AP QUESTION Amt $ Posted]:[AP QUESTION Amt $ Posted])

John Jonassen

You actually needed to add another SUM to the mix...after your subtraction sign. So, Sum the Vendor Question Amount Credit, minus the Sum of the AP Question Amount $ Posted. It should look like this:

=SUM([VENDOR QUESTION Amount of Credit]:[VENDOR QUESTION Amount of Credit]) - SUM([AP QUESTION Amt $ Posted]:[AP QUESTION Amt $ Posted])

Melanie Sanders

THANK YOU, John Jonassen!