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.