Access Formula Gone Wrong!

Hello Everyone,
We have a Query that is used to calculate the employees profit:
Profit: (([GPACT_AMT]+[GPBONUS_AMT]+[GPSUBSID_AMT]+[GPSUB2_AMT]+[GPSUB3_AMT]+[GPFEAT_TOT]+[GPSALES_AMT])-[GPCOST])

Now this query work fine most of the time except when there is a return and so we could get numbers like this:

Profit: (([-290]+[0]+[0]+[0]+[0]+[-7]+[-299.95])-[404.95])
The Number should be -$192 instead it calculates out as -$1001.9

Can anyone elaborate a better way to present this formula so it works correctly?

Thanks Again!
Jester

smart2009Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
there is nothing wrong with the formula.
it gives the correct total

explain why you think otherwise
0
 
Eric ShermanConnect With a Mentor Accountant/DeveloperCommented:
I agree ... if it's a return wouldn't you want to offset (subtract) from your regular sales as shown in your example???

ET
0
 
smart2009Author Commented:
Thanks Again!
0
 
smart2009Author Commented:
Sorry it doesn't appear to have added my comment. The issue was that GPCOST was supposed to always be a positive number and the Point of Sale System had a glitch and had placed negative numbers for that field. It has been resolved. Thanks again!

Jester
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.