Cross Tab Embedded Summary Formula Help
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21717
Printed Date: 06 May 2024 at 8:03pm
Topic: Cross Tab Embedded Summary Formula Help
Posted By: bspencer1
Subject: Cross Tab Embedded Summary Formula Help
Date Posted: 02 Oct 2015 at 10:45am
|
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/ - http://postimg.org/image/900b9n45z/ direct link to image if you can view it)
 |