Recent content by JustinPorter

nevermind, I got it using grid values. One more thing I promise! How can I do a "New Page After" a certain row?

The second formula, it selects "gridrowcolumnvalue" and says This function can be used only within the context of a value grid

What is the formula I can use to find the difference between grid values? Everytime I try and do it, it returns an error saying I need a value. GridValueAt (5,CurrentColumnIndex,0)/ (GridValueAt (5,CurrentColumnIndex,1)+ GridValueAt (2,CurrentColumnIndex ,1))

See the attached document. In each column, I want to take the average of the sum of the two amount fields (red) devided by the one count field (blue).http://cid-53358344fba766d3.skydrive.live.com/self.aspx/Public/summary.JPG

I'm having a problem selecting the correct fields. For the amount, I only want the two TOTAL feilds with the dollar amounts in them, and for the count I only want the green fee count total.

Sorry yes - specified order. I figured out how to do the "subrows" with formulas so I'm good there. This is what I have. Columns @Year: totext(month({PROSALES.SDATE}),"00")+"-"+totext(year({PROSALES.SDATE}),"0000") Rows {PROSALES.SDESCRIPT} with specified order. @Courses: if...

My new roadblock is getting the subcategories. Columns are set up with the formula you helped me with on the other thread. It is called YEAR. Rows are set up with {PROSALES.SDESCRIPT} and grouped using "like" formulas. (i.e. Member Greens Fees, Member Cart Fees, Resort Greens Fees, Resort Cart...

LB, Thank you for offering to help, it is much appreciated. I also am running into another road block I am hoping you can point me in the right direction with. I am using CR2008 My crosstab is set up like this: Rows: {PROSALES.SDESCRIPT} Jan07 Jan08 Jan09 - Feb07...

The report is a consolidated revenue report. I'm looking for columns like: Jan-06 Jan-07 Jan-08 Jan-09 | Feb-06 Feb-07 etc Members 5 25 98 45 45 48 Guests etc

Just to add. I actually need to take the sum of the two summaries and devide it by one of the counts.

I have a crosstab set up with rows being groups and collums being dates. In the middle I have the sum of the information and the count. I have added a summery feild after the first 2 groupings and I'm looking to take the sum of one of the summeries and devide it by the count of another summery...

This is exactly what I needed! Is it possible to have it show the month as well as the year?