Search results for query: *

Thank you for all of your help.

doh i took too much out, i have some names i didnt want to post on the forums so i tried editing it to just say workbook and didnt realize i took out the formatting too. This is what it looks like: =IF('[Workbook1.xls]Trend Analysis'!$R$2 > 79.9%,'[Workbook1.xls]Trend Analysis'!$R$2,"")

i did the mouse click, i didnt type in the reference, i opened up both workbooks and just clicked on the cells i wanted to reference. I have a feeling that the iferror is whats causing the #name? but there has to be a way around that.

if it helps i do have excel 2007, maybe there are extra features that can alleviate this problem.

doh! that didnt work i get the same error :(

Hello, I have two excel workbooks. The first excel workbook has a cell with the following formula: =IFERROR(AVERAGE(B2:P3),"") The second workbook has the following formula to reference the first workbook. =IF('Workbook1!$R$2>79.9%,'Workbook1'!$R$2,"") I only want it to show the data if the...

Thank you very much GS i think that will work for what i need. One more thing i was wondering if its possible. Can you take a number in excel like 301.00 and truncate it so it drops off the 30 in front of it so it only shows 1.00?

sorry i think i messed up when i said average mean. Let me explain in detail what i want. I cant for some reason think of the word to describe it. We have a standard where if someone is scheduled to work at 1:00 AM every day 5 days a week. We get the average login from another report. So for...

I need to convert a time into numbers so that i can take those numbers and put them on a weighted average. I couldnt figure out how to do this easily so i came up with the following formula: =if(j2 = "12:50 AM",10,"") i want 1:00 AM to be the average mean and if its 12:50 to 1:00 AM i want it...

Ok i have scoured this site looking for a way to do this and i cant so im opening it up for discussion. I have 6 excel worksheets in a single workbook. The first 5 worksheets has data that pulls from other workbooks. I am trying to compile data across other workbooks into one single workbook...

I have a chart that shows the Average Cycle Time for a range of data. It works fine but for some reason anything outside the date range im selecting is being zero'd out and shows up on the graph as a zero. I cant figure out a way to get rid of it. I cant use the select tool because there are...

I am trying to a report that shows details about the surveys we send out for tickets that get created. The survey data is located on a specific table. I have created the following command to get this particular data as follows: SELECT CAST(call_req.persid AS nvarchar(30)) AS persid...

I was able to achieve what i wanted by adding the worksheets in the reference workbook as datasources. It works great now, thanks for all of your help guys :)

ya im trying to work it so that i have one workbook with all the values that i can change, so that the other workbooks get updated automatically with the updated lists.

Another Workbook

Is there a way to create a drop down list in Excel where the data in the list references another workbook?

its really strange, i kind of inherited this report from another program. The command that is listed is nothing more than a stored procedure located on the database. I went into the stored procedure and it is so convoluted and confusing i just left it alone. So all the modifications i have...

hmm in Field explorer it is greyed out to add anything new. Is it because i already have a SQL command for this report?

its hard to explain but with this particular report i do not have access to do sql commands for it. Is there a way to do this within crystal reports using formulas?

Thanks to LBASS i have the following formula for calculating the average number of agents for each time frame. //{@accum} to be placed in the {@timeint} group footer: whileprintingrecords; numbervar int12to7; numbervar int7to5; numbervar cnt12to7; numbervar cnt7to5; if {@timeint} = "12:00 to...