Skip to Content
0
Former Member
Nov 26, 2008 at 01:06 AM

Crosstab Report: calculated field in detail of report

42 Views

Hi,

I am a bit of a novice in Crystal and I am trying to incorporate a formula in a crosstab report. An example of what I am trying to achieve is below:

...............Location (column)

.............................Location 1................Location 2

Cost (row)

Rent......................SumCost..PSF..........SumCost..PSF

Utilities

Tax

I can create the report with the Location, Cost and SumCost, but I cannot determine how to add a calculation for Per Square Foot (formula: SumCost / area (square feet) --> from database field).

I appreciate any help offered.

Thank you.