Recent content by ejerblom

Thanks all for your help but I need some more. Well, it did work, 20% of the highest values were removed. But I still have a problem. I need to count and summarize the records that is left after the removal of 20%. Can it be done? I have no group. /Ulrika

I need to remove 20% of the values and the 20% that I remove must be the ones with highest value. For example if I have 20 different values I need to remove the 4 highest values. Is it possible? Ulrika

Hi, I would like to make the following calculation in my report: I have a list of values where I would like to remove 20% of the highest values. So, anyone who knows how to remove 20% of the highest values from the list? Regards Ulrika

Hi, I wonder how you can remove the seconds from a date/time value. The date is displayed like this: 2004-01-25 11:45:45 but I want no seconds, I want it do be displayed like this: 2004-01-25 11:45 Because I want to compare the dates with no seconds. How can this be done? Regards Ulrika

I took a look at the code (FAQ767-3543) and I still have one problem. I also need to exclude weekends and holidays. Therefore I have made the following code for this: WhilePrintingRecords; DateTimeVar Start := {Incident.ReportedDate}; //Replace this field with your Starting Date field...

Hi, Does anyone know how to convert a number into hours and minutes? The following code generates a number for example 1.42: WhilePrintingRecords; NumberVar Days := {@Weekends and holidays}; // The field that calculates your business days TimeVar SetStart := TimeValue("00:00")...

Hi, Thanks for information. I have tried to find the dll (CRUFLWDAY.DLL) file on www.crystaldecisions.com but I can't find it. Am I looking at the wrong site? Regards Ullis

Hi, I wonder if anyone knows how to solve the following: I have calculated the hours between a "Reported date" and a "Resolved date". Sometimes the "Reported date" occurs before a weekend and is resolved after the weekend. But the calculationen shall exclude...

Thank you very much, it worked very well. Have a nice day! /u

Hi, I'm a new user of Crystal reports and I'm not familiar with the formula yet so I hope someone can help me. Problem description An incident have a reported date and a resolved date. My task is to calculate the percentage of incidents solved within 1 hour. My soultion (that is not working)...