Formula help!!! - Difference (-) of 2 count fields as cross-tab field 1

[EagerBeaver]

I need a formula which would substract the count summary of two seperate fields and report it in the summary section of a cross tab report.

for example.

I want to count all issues received in a particular month sunstract them from all issues resolved for that month plus the result of this formula from the previous month. I want this to show in the summary field of the cross tab report.


Please help

 

[kenhamady]

First the Bad News:
Crystal can't write a formula that refers to a cell in a cross-tab. You also can't use a formula derived from a summary field, as a field in a cross-tab.

Now the good news:
You can write a formula on the details and summarize it in a cross-tab. Like:

If termdate in MonthToDate
then -1 else
if admitdate in MonthToDate
then 1 else 0


More Bad news:
You can't have one record appear in two different parts of the same cross-tab. So a case opened in July and closed in September can't be counted in both places of the same summarized field.

I have done these "rolling case" reports, and they take some work. You basically have to hard code each cell of the report as a conditional total, or a field that adds/subtracts the conditional totals.




Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)