Search results for query: *

Hello - I am trying to parse the first name out of a field that is formatted Last, First Middle. I have a formula that has worked well but am now getting the error "Invalid length parameter passed to the LEFT or SUBSTRING function" because someone created a name without a comma - the name is...

I am using this formula to display parameter selections. It is displaying the result with two values past the decimal point. Example, 35.00. I want to display only 35. Can someone recommend a way to modify this formula? thank you! BeforeReadingRecords; stringvar PrintString := ""...

I am trying to format a string phone number field from the current xxx-xxx-xxxx format to (xxx) xxx-xxxx. I reviewed the posts in threat 767-608674 but I am not able to get the suggested formulas to work. This is what I have now: stringvar fmtPhone...

I have a report that displays all departments a patient has been in during their hospitalization. The report is grouped by Patient Account, a field in the details lists all departments the patient was in. Sample with relevant fields: Group 1 : Patient Acount - 1234 Patient Account Dept ID...

Hello, I have been looking at previous posts but don't see anything that fits my specific scenario. Can anyone help with this? I need to count a record if it meets 4 specific criteria. I have tried writing the formulas separately and bringing them into a running total using "Evaluate using a...

Looking for a formula to remove the decimal point from a VARCHAR field. Example: 064.10 = 06410 The formula needs to retain leading or trailing zeroes. Thanks!

I am not able to get the result of this If Then Else formula to display in a group header. if (not isnull({IP_FLWSHT_MEAS.FLO_MEAS_ID}) and {IP_FLWSHT_MEAS.FLO_MEAS_ID} = "4409" ) then {IP_FLWSHT_MEAS.MEAS_VALUE} else "*" The report is grouped by Patient Encounter ID. The formula displays...

I need to calculate the average of a summary field. I need to calculate the average # of days a patient is on a ventilator for each unit. The report is grouped by Unit and Patient Account #. # of ventilator days per patient is a summary field: Patient Name On Vent Y/N Patient A -...

Is there a geometric mean function in Crystal? If not, does anyone have a suggestion for how to calculate? I am using v8.5.