Skip to Content
0
Former Member
Apr 08, 2014 at 06:50 PM

Average In CrossTab Report

168 Views

Hello I am having extreme difficulty in getting this done and my searches via Google show averages over one variable. Below I am trying to get an average Fare based on the Revenue and passengers. This is contained within a group Country in Crystal and hence the formula I am using is

Sum ({2014.REVENUE},{2014.FLIGHT#})/Sum ({2014.PAX},{2014.FLIGHT#}).

This does not work and it also repeats the result as in the below. Can anyone please guide me where I am going wrong??

Thank you so much in advance.

Avinash

Attachments

CR2.png (5.2 kB)