Summary fields  adding one column and subtracting a second column
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!
Best Answer

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])
Answers

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])

THANK YOU, John Jonassen!
Help Article Resources
Categories
Check out the Formula Handbook template!