Search results for query: *

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)...

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...

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 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...