Search results for query: *

My spreadsheet currently has 26 weeks worth of sales information brought in through a pivot table with this format. There are of course 100's of part numbers. I have the column for the percentile. Previously I have manually calculated what the total dollar sales were and then figured which...

Thanks so much that might work, but I am hoping for something a little different. Let me explain a little more of what I am trying to accomplish. I am using this spreadsheet to calculate safety stock qtys for a distribution center. The bottom 20% get one zscore, the next 20% get another...

I am needing to determine the percentiles for a list of part #'s. I need to do this based on the $ amount of sales. I tried using the percentile function, but that bases it's calculation on the count of the items, not based on the total dollar amount. What I need to find out is what accounts...

I have a spreadsheet where I have dimensions entered in as feet. I would like to be able to format the text so that it shows in feet and inches. For example 7.25 would be shown as 7' 3" Thanks, waters130

Is there anyway to create an if statement as a calculated field in an Excel Pivot Table? I have a report that I download that shows the % of inventory above Safety Stock. I need to count how many are less than 10%. My initial thought was to create a calculated field that says if(qty<=.1,1,0)...

The new version of Jet didn't work, but we found that we needed to reregister the DLL's. Thanks to everyone for your help

We tried doing a repair and it didn't work. Any other ideas?

I have a daily excel file that needs to be imported into an access database on a daily basis. On my computer I get the option to choose the Excel format, but other members of my team do not have that option. We are all running Access 2003. What options do we need to select to be able to...

Thank you so much! waters130

I am trying to create a bar graph that comes off of data out of a pivot table. The data will change depending on what warehouse or product class that is shown. The fill rate percentage is calculated and then shown on a bar graph. The problem is that some days, nothing is shipped out of a...

I didn't look close enough at the nested iif statements.

Thanks Skip, I appreciate all your help.

That helps give me a good idea of what to do, the criteria for the other other weights (other than the .5) need to look at weeks 5-8 and 9-12 not just the current date -28 days, how would I do that?

I am trying to create a calculated field in Access that needs to have the following criteria. I am doing a weighted average of sales for a forecast. The previous 4 weeks sales qtys need to have a weight of 50% The 4 weeks previous to that need to have a weight of 30% and the The 4 weeks...