Search results for query: *

Sorry - Sharepoint 2010!

I have (what I think is) a very simple question... When using Sharepoint 10.0, I added a Content Query Web Part to look at a list and return a subset of that list based on a single field. In the filters, I want to have anything that contains '*Need*', but I can't figure out the syntax that...

Perfect - that worked! Thanks so much for your help!!!

My cross tab looks like this: Rows: @ItemType Columns: @ProcDate Summarized Fields: {@0} What summary calculation should I use on the @0?

Thanks! I got this to work correctly in the group footer section, but I'm not seeing how to place it in the cross tab correctly. When I add it, the value shows 0.00 rather than the 1.48 that I'm expecting...

Sorry - this was a later addition. I have a group for location, so that each location will have its own crosstab.

Thanks lbass, I missed that last step, which was the reset on location. They are showing up correctly now!. The last question would be how to incorporate this into a cross tab report, if it's possible at all. Down the left side rows, there is an item category. The columns across the top...

There are no null values in this field, as it is required for any record entry...

OK - I got past that issue. But the average seems to be for all data, rather than grouping by site and type. I have a grouping for Location, and one for CaseID. In the footer of the Location, I have the following formul fields: StentCounts: count({INVENTORY.ITEM_NUMBER}...

Yes - I've added my own field but get that error...

I tried this, but it says the count (ItemID) cannot be subtotaled... Any ideas why?

It seems like this should be easier than it is turning out to be, but I can't get this to work! The Case table has the case ID number. The Inventory table has the Inventory ID and item #. There can be several different item #s for each case ID, and even several of the same item # in each case...

Hello! I'm new to Sharepoint and am having fun trying to figure out how to make certain things work in this environment. I currently have a list set up that looks like this: Interventional Cardiology When you click on that title, it opens up and displays more items under: Interventional...

I did do that, and it brought the numbers back down, but they are about 25% lower than expected, based on manual counts...

Yes - I can verify that. It's all caps.

Here it is: //{@Cancelled} if {CATH_PROC.PROCEDURE_NAME} like '*CANCEL*' then 1 //{@Interventional} if {CATH_PROC_V.CASE_TYPE} = "Interventional Cath" then 1 else if {CATH_PROC_V.CASE_TYPE} = "Interventional PV" then 1 //{@Count}: if sum({@Cancelled},{CATH.CATHID})= 0 and ( (...

Something isn't quite right here... The numbers exploded exponentially! Instead of a few thousand, now it's several million!

Sorry - Missed it from above. I see it...

What is the @Null?

The counts here are basically to determine the type of case. A case can be Diagnostic, Interventional, or Diagnostic and Interventional. If it's both, only the intervention is counted - not the diagnostic. I'll give this a try - thanks so much for your help!