Calculate average between two fields

[#1]

Guys,

I have to calculate an average of Ticket Price.

Formula will be - Sum ( Total Base Fare Amount ) / Sum ( Ticket Count)

My question is how can i achieve this QlickView ?

Please Help !

Thanks,

[its_anandrjs]

For this write expression like

=Sum (Total  [Your Base Fare Amount Field Here] ) / Count (Distinct [Ticket Field Name])

Or

=Sum (Total  [Your Base Fare Amount Field Here] ) / Count ([Ticket Field Name])

if you have sample then provide.