Search results for query: *

If there are no commas, I would like it to file to the Last Name, which I have figured out with this formula: ,CASE WHEN CHARINDEX(',', TABLE.NAME) = 0 THEN TABLE.NAME WHEN CHARINDEX(',', TABLE.NAME) <> 0 THEN SUBSTRING(TABLE.NAME, 1, CHARINDEX(',', TABLE.NAME) - 1) END AS last_name I...

SkipVought is correct, spaces are not a reliable delimiter. But thank you for the response, Andrzejek.

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

Thank you!!!

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 := ""...

That did it - you understood perfectly. Thanks so much!!!!

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

Thanks for the direction, I made a few modifications and got it to work. Thank you!

Thank you!!! I've incorporated the formulas into my report and it appears to be working so far. I need one minor change - when it is determined that there is an icu record, I need to display the department name {table.DEPT_ABBREVIATION}. How do I include that in the formula?

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

Thank you lbass - that worked perfectly!!!

Yes, that's right. I need to evaluate all the records for the condition to determine vaccine eligibility. Thanks again.

I'm not sure the OR statement will work - isn't this saying condition 1 is True OR condition 2 is True OR etc... Or am I misunderstanding how this OR statement works? A patient can meet one of the critieria but then have an exclusion so they are not eligible for the vaccine. All conditions...

It does work using "or" except it is not giving me the right results. I need to count them if they meet all criteria, not just one. I changed the "or" to "and" but then the running total returns only zeros. Here is a the formula I wrote: ({IP_FLWSHT_MEAS_influenza.FLO_MEAS_ID} = "5987" and...

Thanks for your response. I realize I wrote boolean formulas, I want to count the record if the results of all of those formulas are "True". You are correct that Table.ID is a multiple value. The report should count patients eligible to receive a flu vaccine. Here is a sample of the data...

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

So simple - thanks!!!

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!

Thanks lbass - it works!!! Appreciate the help!

On further investigation, the max formula does not seem to be working. I have two test patients in my report and the formula is returning the same value for each patient instead of resetting when the group changes. Appreciate any suggestions you may have to get this to work. Thank you!