Search results for query: *

I have a list of sales $ by store for 3200 stores. I am trying to Rank each store A, B, C, D based on sales level. I want to take the overall average of all 3200 stores, the stores above that level are A or B stores, the store below that level are C or D stores. Once I have the overall average I...

I have an ongoing problem with calculations not calculating. I have a very large workbook, 20+ sheets, I am using named formulas. I have "enable iterative calculation" checked. The problem I have is some of the formulas do not calculate. If I use a named formula 100 times and it does calculate...

I am using Office 365 Excel 2016. I am using Macro 1 to lock all sheets in the workbook. It pops up a message box so I can enter a password, verifies the password, and protects all the sheets. If the passwords do not match, it starts over. I would like to use this macro in a workbook where I...

I am using Office 365 Excel 2016. I am using Macro 1 to lock all sheets in the workbook. It pops up a message box so I can enter a password, verifies the password. and protects all the sheets. If the passwords do not match, it starts over. I would like to use this macro in a workbook where I...

I am trying to open a delimited file while in my original workbook so I can paste the data into my existing sheet. I have the following macro which allows me to find the file but it does not go through the import wizard. Sub Import_Data() Dim strFileToOpen As String strFileToOpen =...

I have a booking report that currently compares YTD booking with Prior YTD Booking. The complete selection formula is as follows and is working without problems. {oeel1.custno} <> 100052.00 and ({oeel1.enterdt} in LastYearYTD or {oeel1.enterdt} in YearToDate) and {oeeh1.transtype} in ["CR"...

I have 2 sales rep groups, within each sales rep group there are 3 sales reps, each sales rep sells 4 different product categories. Group 1 is the sales rep group Group 2 is the sales rep Group 3 is the product category. I current have a report that properly groups the sales for each category...

Crystal Reports 2008 Progress Database Sorry I am sure this is a basic linking or joining issue. I am not a programmer and getting into SQL coding `will push this to the programmers and i will fall to the bottom of the schedule. I have two tables, a product table and a sales table. The common...

I am selecting a variety of of data from order lines. I use 2 of the fields to group the data, the 2 fields are. Group 1 {Oeel.prodcat} Group 2 {Oeel.salesterr}. Both fields are string fields that contain numbers. These fields are both Linked to {SASTA.codeval} however in the SASTA table...

I have pulled data for items sold to all of our customers. I do a distinct count of SKUs sold to each customer. The customers are grouped by sales rep. I have a parameter that allows me to show only the customers that have purchased more than "X" sku. The report works fine except for the...

First thanks in advance for the help, I am a low level technical users designing a few reports. I have a report that I would like to schedule run Monthly using a date range. and i am having problems figuring out the formula. The date range starts on 07/01 and ends on the date the report is...