Search results for query: *

All solved... Thanks for pointing me in right direction Kray.

oops forgot to mention that this was Business Objects 5.5 I can calculate the hour one, but I can't seem to get the minutes to reflect the way I want to. I appreciate the advice....

Simple question... I would like to convert a field showing minutes into 2 separate fields, one for hours and one for minutes... For example, If I have a field that shows 80 minute, I'd like for the end result to show 1 hour in one field and and 20 minutes in another. Any help would be...

Hello group, Hopefully not to difficult of a question. I was hoping someone could show me in Bus Obj how to convert multiple lines of data (belonging to same record) and displaying it on one line only. Right now, I have a simple query that shows: Case# Surgeon Procedure DelayReason...

Thanks Nimmy99 for the quick response. I should have expanded my request with a more detailed example. Lets say this SURGEON DESCRIPTION field is a "free text" field showing the following data returns: Case # Surgeon Description 001 " Possible Incisional Hernia Repair With Mesh"...

Novice here with hopefully a simple question/query...... I have a field called "Surgeon Description". Once in a while the records show the word "possible" embedded in the field. I'm trying to create a variable to isolate these records that contain the word "possible" but can't quite seem...

Steve & Ties, A million thanks for all you do.... You're the best!!!

I work at hospital and write simple reports in BO. Hope this is an easy one and you can assist me. To simplify, Lets say I have the following 4 fields: Case Date, Case #, Procedure, Free Comments For some reason, certain days will not have "Free Comments" populated, therefore I will get a...

Hello All, Simple problem that I hope you could assist. In a report, I have 2 fields that are dates but are "dimensions" rather than "measures" . I'm simply trying to find the difference between the two dates, quoted in "days". They are as follows: Field one = Case Date Field two =...

Hi Ties, Once again, thanks so much for your help... got it to finally work...:))))

Thanks blom0344, i tried the suggestion, yet, i'm still getting error message. I'll tweak it and let you know what I come up with. But thanks for your suggestion.....

Ok... newbie here with real bone head dillemma.. In short, I've created a report to simple show how many cases in my hospital were "late" or "ontime". I'm trying to express this as a percentage, yet in trying to do so, I keep on getting errors. I first, created a new variable called STATUS...

Newbie here with simple question In Business Objects. Field 1 = Start Time ( which is a dimension) Field 2 = Stop Time ( dimension again) Field 3 = Elapsed Time ( measure) Example: Room Time Start Time Room Time Stop Elapsed Time 10:07 11:53...

I work in a hospital and we're trying to find the average turnover time between cases in each of our Surgery rooms however we need to exclude the first record for obviously this would be N/A. I'm hoping this is something pretty easy to solve: I have the following fields in a table: Case Date...

Was wondering how to create a chart from a table just showing the Average Times values against 4 entities. For example: I have 4 surgeons that show average times for a common procedure which are shown as values in a footer. Surgeon Avg Times Surg a 120 Surg b 84 Surg c 91...

Was wondering if it is possible to merge cells together as in Excel. I've created a Crosstab, and I'm trying to add a header to top by first, adding row above, and now I'm trying to merge the 4 or 5 cells so I can input my text. Tried to look at format cell, but to no avail.... Any advice...

Hi there, newbie here... I have a column called case numbers (case_num). In this field I have numerous duplicates that I separate out. After exporting to Excel, I create a second column that carries the following formula: IF(COUNTIF($A$1:$A$100,A2)>1,"Duplicate") From...