Sum not working, being multiplied

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone, for the past 3 days I've been having this problem, where
certain fields were not being calculated correctly. Ok, so I figured out
that I needed the NZ in the formula. Now I want to sum everything up, like
Jan-Jun ships + Jul-Dec Fcst, but the result is being is either twice, 3 or
six times bigger than it should be. What could be wrong?
 
I figured it out, I wasnt applying the Table name to the forumla. It's
coming out right now, thats weird though. But I learned something new.
Thanks a million Karl.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Sum Range Based on Date Chosen from Drop Down List 1
Moving Sum Omitting Low Values 11
Average/Sum formula with offset 5
Grouping periods & running sum - PLEASE help if you can! 8
Search yields no results to calculate number of days based on Rang 5
query fields 4
Crosstab, Quarter Sum isn't working 6
sum formula with overlaping references 2

Back
Top