I'm trying to do a calculated member in a cross tab report, to show the difference in percentage from one year to the next. Some of the values are zero, though, and Crystal won't run the calculation when there is division by zero.
How can I edit this formula to take care of that? Here is the formula Crystal comes up with when I try to do my calculated member:
//The calculation formula is used in place of the summaries in Calculated Members.
// This calculation formula must return a/an Number value.
GridValueAt(CurrentRowIndex, GetColumnPathIndexOf("Jan 2009"), CurrentSummaryIndex) / GridValueAt(CurrentRowIndex, GetColumnPathIndexOf("Jan 2008"), CurrentSummaryIndex)
Thank you!
IP Logged
