Summarization Problem

[jakecolman]

I have a report with two groups. I need to summarize one of the detail fields in both footers. The problem is that the requirements specify that under certain conditions, the value in the column being summarized should be blanked out and its value not included in the summarization. If I replace the data element with a formula that either return the actual value or zero (and format the field such that zeros display as blanks), I cannot use the summarize option since "it is a non-recurring field".

How can I create a formula that returns the actual data element or zero, based on a condition, for the detail value and can still summarize at two different group levels?

Thanks!

...Jake

 

[synapsevampire]

Depends on the conditions, posting sepeicifcs is better than making us guess, and supplying basic technical information is best, such as the Crystal version and database type.

IF you use conditions, use an else so that a summary can use all rows, such as:

if {table.field} = "condition" then
{table.field2}
else
0

These will summarize properly.

-k

 

[jakecolman]

Thanks. This works and I don't understand why I ever had a problem. I am certain that this is what I tried yet it woudn't summarise for me. In any event, thanks for the reply.