Cross Tab formula problem

[Oscar115]

For some reason I have a difficult time creating a crosstab formula that can be inserted into the crosstab.

An apartment complex's accounting system,

There is a description field dstatusno that indicates the month the the rent/payments/adjustments are associated with, example 02Rent(February Rent), 03Rent (March Rent), etc.


Code 01 is used to indicate the rent billed, namount, if dstatusno.
Code 11 is used to indicate the rent paid, namount, if dstatusno.
Code 10 is used to indicate adjustments (+ and -) in rent, namount, if dstatusno and namount > 0.00 else if not dstatusno and transaction in date range.

total rent billed is the sum of codes 01 and 10(+/-).
total rent paid is the sum of code 11.


I cannot use the transaction dates per code because as you can imagine, some rent is late, some rent is paid early, some adjustments are made to rent before or after the fact.

I am grouping these figures by apartement complex and by month and need to calculate the percentage collected for the complex and month and insert that in the crosstab.

I have existing running totals for the amount billed and amount paid.

I cannot seem to use these running totals in a formula to insert into the crosstab.

Any suggestions would be greatly appreciated.

 

[Madawc]

If you create a formula at detail-line level, you should be able to include it in a crosstab. This does depend on your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. Always worth mentioning.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP