Search results for query: *

...it to produce 2 then 3? Many thanks in advance! Formula: =IF(D2="E",0,IF(D2="S",1,IF(AND(B3<>B2,OR(D2="D",D2="G")),SUMPRODUCT((A$2:A$65536=A2)*(D$2:D$65536="D")*(C$2:C$65536<C2))+SUMPRODUCT((A$2:A$65536=A2)*(D$2:D$65536="G")*(C$2:C$65536<C2))+2,""))) Sample Data and results EmployeeID...

...Formula to Sum Based on Employee ID" (see my earlier thread in the Microsoft: Office Forum). =IF(NOT(AND(A3=A4,C3=C4)),SUMPRODUCT((EmployeeID=A3)*(Relation=C3)*(Premium)),"") Btw, I tried using Excel's built-in Data > Subtotal feature, but it inserts rows to produce subtotals at each change...

Thank you Skip, I will post a new thread on the VBA Forum. Btw, your suggestion to use the built-in Data > Subtotal feature is a good one, but it inserts rows to produce the subtotal at each change of EmployeeID. I only need the subtotal amounts to display one column to the right on change of...

...to do the same as my earlier post but use Excel VBA instead of using the SUMPRODUCT formula: =IF(NOT(AND(A3=A4,C3=C4)),SUMPRODUCT((EmployeeID=A3)*(Relation=C3)*(Premium)),"") I was able to modify Dave Pearson’s code to do most of what I need...

Skip, Your suggestion is an excellent alternative.

Greatly appreciated, thank you!

Can Excel formula evaluate the string in a cell (e.g. A2) to see if there are duplicates and delete them? For instance... A2 cell value is shown below (separated by spaces) C10-98 ENH C10-98 ENH RAD C10-98 INT Needs to be C10-98 ENH RAD INT Help if you can..thanks!

Skip and Gavona...your help was most valuable. Thanks!

SkipVought you're fantastic! And thank you very much for quick response. Your formula calculated running totals OK for 'E' and 'S' Relations but for some reason it is not doing for 'C'. The EmployeeID = 123456789 has four 'C' premiums ($6.50, $6.50,$7.00, $7.00) that are not totaling up to...

Need help getting running totals in column E based on EmployeeID and Relation (E= Employee, S= Spouse, C= Children). Sample data definition: Column A = EmployeeID is ID of Employee Column B = InsuredID is ID of Insured (Employee, Spouse, Children) Column C = Relation is relationship of insured...

...@Sev1 DPMO //DPMPO for Service Restoral Sigma (Sum({HierarchySummary.Sev1_Restoral_Defect_Count})/Sum({HierarchySummary.Sev1_Restored_Count})) * 1000000 @Sev1 Percent Defect //Percentile of defects...

Does anyone know if Crystal Reports 10 (Professional) has a function to calculate process sigma? BTW, the database is SQL Server 2000. The Crystal Report already returns # of opportunities and # of defects. I just need a Crystal Report function or formula to pass two variables to (#opps &...

Thank you synapsevampire for quick response. Please pardon me, I was not too clear about datasources. This report only uses DB2...the other two are used in creating other reports. Yes, I agree with you about using a formula vs. a custom function. However, we've been asked to build this...

Greetings: I am using CR10 Pro & Datasources are DB2, MS SQL Server 2K and Oracle. I tried to create a custom function using IsNull to check for a NULL datetime field value but this message displays "This function cannot be used within a custom function." Is there some other syntax that can...

Ido - thank you very much!! Your suggestions were great. Only had to make one adjustment to the @Final_Sort: Converted @Sort to string to eliminate check message "A string is required here" (and {@Sort} is highlighted). Changed it from ==> If {?ProblemID} = "ALL" Then {rootcausem1.ID} Else...

Really appreciate your response above... As per your post, I created the @Sort formula but was unable to create the @Final_Sort formula. I get this message: "A string array is required here" (and {@Sort} is highlighted). This is what I have for @Sort: ==============================...

Hello Ido: I found your post below and found it very helpful for a report I am working on. Currently using CR 10 PRO and datasources are DB2, MS SQL Server 2K and Oracle. The report needs to have ability for users to enter Problem IDs and have the report sorted in the order the Problem IDs...

synapsevampire and lbass Appreciate the feedback...thank you.

Hi synapsevampire: Currently using CR 10 Professional...will be upgrading to CR XI Developer. Datasources used are DB2 and SQL Server databses. Currently my skill level with SQL is minimal - as you can see I was able to decipher part of the command into Crystal syntax and I am better able to...

Can anyone help in translating a Crystal Report "Command" into Crystal Report "Record Selection Criteria"? My SQL knowledge is limited, but I can determine tables and fields the command uses. There are 7 tables as follows (in parentheses is the non alias table name): amportfolio p (AMPORTFOLIO)...