Crosstab Formula Trouble

[shelby55]

Hello

I am using Crystal 9.0 reporting off of an Access 2002 database.

I am trying to calculate number of beds using a cross tab report. The formula is # of patient days/(days in period*.85). In a non-cross tab report the formula would be:

Sum ({@TotalDays})/((DistinctCount({?Disch Date})*.85))

Any and all assistance greatly appreciated.

 

[lbass]

What is the content of {@TotalDays}? Why are using a parameter for 'days in period', when it looks like the parameter is for a date? That would just give you the number of parameter instances you chose at the prompt. Why are you using a crosstab report? How is it set up (rows, columns, summaries)?

-LB