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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!