Search results for query: *

I need to convert an AR Days report that I did in Crystal Reports over to Cognos Report Studio. Most of what I need for the report is complete aside from the last calculation which was quite complex in Crystal. User lbass helped me with this great code for the Crystal report which worked very...

I am doing a Profit and Loss report where I have a calculation of EBIDA (which is revenue - expenses) that must appear below expenses. It should have this order: Revenue Data Revenue Total Expenses Data Expenses total EBIDA Other Income and Expenses Net Income (EBIDA - Other inc and exp)...

I have a graph that is formatted to show the following date format: Jan-11, Feb-11, Mar-11, etc, for example. I have converted the table date data in the following manner: @ToDate = cdate({@Year},{@MonthConvert},01) where @Year = tonumber({tbl_Convert_Calendar_to_Fiscal.Calendar_Year})...

thread767-1635183 My goal is to create a report showing the number of AR Days per month per hospital as indicated by the following array: Hosp1 Hosp2 Hosp3 Total Month1 x x x x Month2 x x x x . x x...

I have the following array: Column 1 in $ Column 2 in $ % Col 2/Col 1 GH1 Year GH2 Month GH3 Patient Type GH4 Hospital GF4 $amount $amount x GF3 $amount $amount x...

My goal is to determine, first, the difference in dollar amounts between months and then calculate the average difference. I have the following data for example: Month 1 $446.4 Month 2 $486.7 Month 3 $458.5 Month 4 $455.8 Each dollar amount is a result of a formula calculation where...

thread149-1393583 In referencing the above closed thread, I realized I had the exact same issue as the poster. My goal is to graph numbers by dates with dates being on the x-axis. The format I wish to achieve is, for example, Dec-10, Jan-11, Feb-11, etc. I figured out how to do this by using...

I have a report with data that resembles the following: Pat ID Code 405377353-1 22255 405377353-1 63201 405377353-1 25894 405377353-2 0762 405377353-3 0651 There are a few other fields as well to the right that are not necessary to show here and many other Pat ID's, most with...

I am doing a report that shows the number of financials that came in for an entire month over a 12 month span. The report will include one calculation that will calculate the rolling 12 month average of those 12 numbers. For example: Jan-10 $1M Feb-10 $2M Mar-10 $2M Apr-10 $1.5M . . ...

Hello Everyone, I am working on a Crystal Report where I need to calculate a rolling sum for 3 months of totals that are summation fields. Monthly Revenue Ending Balance Days A/R Days at EOM $54,233,511 $79,748,693 31 - $54,847,932 $77,915,945 30...