Search results for query: *

Hello, Need help with Sumproduct to assign correct Dependent Number when there are twins. I'm using the formula shown below but it produces two records with a Dep Number = 2. But how can I get it to produce 2 then 3? Many thanks in advance! Formula...

Greetings, I am trying to use VBA instead of the SUMPRODUCT formula shown below which I used for "Excel 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...

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!

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

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

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

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

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

I have a report where users are allowed to enter multiple values for a "Device_OIG" parameter. The "Device_OIG" parameter is setup as follows: Value type - String Options: Allow multiple values Descrete value(s) Set Default Values: Browse table - devicem1 Browse field - BA_ALT_ARRAY these are...