Search results for query: *

I have a rather large spreadsheet set up that has a lot of range names. I would like to globally change the names without having to reset up all the names. Can this be done? Also, will the formulas that are based on those ranges change as well?

I am a new user to PowerPlay and having problems. I have a measure that is set up in PowerPlay that I need to recalculate. It is a DRG Weight. Why I need to recalculate is because I am combined two (or more) rows into one and the DRG Weight gets added together but what I really need to see is...

I need to create a field that will rank procedure codes from highest to lowest based on eligible amount. How can I do that in Access?

I have a question on how you would create a column in your Access query that will add a count by claim_number from highest billed charges to lowest. I need to be able to determine how many outpatient surgeries were paid the rate1, rate2, rate3 based on billed charges. In other words the...

I have claims that have are multiple lines (or records) to each claim_number. I need to add a count based on the billed amount. The highest billed per line on each claim will get a 1. Then the next highest 2 etc. Then with each new claim_number the count will need to be reset to 1. I am...

I am new to SAS so I need some help. I have a database that has a summary of members in age/gender categories. However the age/gender categories are in columns and I need to rotate the data. So that in one column I have membership and in the other column I have the age/gender category that...

I am creating a report that will give the user a prompt to select a specific Dec # or a specific Ccode. Where Dec # is a group of providers and Ccode is a grouping of Decs. The user needs the ability to either select just specific Dec #(s) or Ccode(s) or to see all providers in requested...

That worked great. Thank you.

I would like to be able to include a formula in the select expert that will allow the user to select if they would like to run the report based on a default date parameter (?Default Date or Select Date) or if they would like to select their own date range. Under the (?Default Date or Select...

I think I am almost there. Here is the formula I used. Datevar MD; MD := Date(Year(CurrentDate),Month(CurrentDate),01)-1; if {?Default Date or Select Date} = 'Standard Date' then {profile:_Stage_II.Inc Period} in Dateadd("M",-3,MD) to Dateadd("M",-15,MD) else...

I am sorry I did not fully expand on my problem. I decided to use maximum Incurred_date because the dates that are populated in the Incurred_date will always be at the end of the month. So like you said if I use current date ran today would give me the 24th day of January instead of the end of...

Thanks I am still having a little problem. I entered the following formula in to my select expert. if {?Default Date or Select Date} = 'Standard Date' then {profile:_Stage_II.Inc Period} in DateAdd('m',3,Maximum({Profile:_Stage_II.Inc Period})) to DateAdd('m',3,Maximum({Profile:_Stage_II.Inc...

Thanks Rosemary I am a little confused... How do you use those statements in your select expert? (i.e. IF ?ReportRanger = "Default" then Date in Date to Date else if ?ReportRange = to X then Y).

I have been requested to create a report that will give the user a choice either a default date range of 12 months ending from Current Month - 4 months or give them the ability to select their own date range. I know I can use a parameter in my select expert and that a parameter field can't...

I need to formula to return 3 months prior. I am creating a report that will use a default date range if the user does not select a preferred date range. The default date range needs to be a 12-month range where the ending date is 3 months prior to the latest date in my date filed...

I know I can not sort by a summed field but I can use Top N Reports. Can I use a parameter in a Top N Report? So the user can choose which summed field they want to sort by. Or is there another way around this?

That worked. Thank you!!

I need to create a report that the user has the ability to select what field to group by. I know that a parameter field can't return a database or formula-field name but I can create a formula based on the parameter field. Then use that formula as the group-by field in the report. The...

Thanks!

I am trying to sort my report using a formula field but my formula fields are not showing up as an option. Here is an example of the formula in case the formula itself is a problem. Sum({Profile:_Stage_II.hhpaid_ibnr},{Profile:_Stage_II.Provider...