if i have 4 of a sku on order but the report is repeating that sku 4 times (b/c of the way the data is set up) is there a way to only have it give me a sum of 4 instead of 16? I can't use MAX or MIN b/c there will be times when I will need it to sum all the values if they are different.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!