CrossTab ratio calculation

building reports crystal reports
1

I am trying to add a calculated field to my CrossTab. Currently, the crosstab shows two values: the sum of A and the sum of B. I would like to show sum of A/sum of B.

Unfortunately, the two “Show as a Percentage” options only allow one field to be a percentage of itself.

Thoughts appreciated.

craibuc :us: (BOB member since 2009-10-19)

2

Hi,

Please try the following:

  1. Create a group on a field used in the cross tab row.

  2. Create a formula namely test. The code will be as follows:
    sum({A},{Field used to create group})/sum(B},{Field used to create group})

  3. Place this formula in cross tab summarized field. Set type of summary as max.

  4. Preview the report

Cheers!!!
Manish

cr_manish :india: (BOB member since 2009-07-30)