I am still having trouble with my embedded summary and am hopeful that somebody out there can help me see the error of my ways. I have an embedded formula in the crosstab below (red) with the following formula:
GridValueAt (CurrentRowIndex, CurrentColumnIndex ,0 ) /
GridValueAt (2, CurrentColumnIndex , 0 )
The formula is working fine for my first row, but does not calculate correctly for subsequent rows. It is basically taking the total from the previous row and factoring it into the formula on subsequent rows. What I need to do is simple. BILLABLE / TOTAL and OH / TOTAL. I need it to reset and show the values in green that you see in my mocked up example in the image below. (
http://postimg.org/image/900b9n45z/ direct link to image if you can view it)
IP Logged