How to get average of a column in terms of another column?

Question

Hi guys.

How to get average of a column in terms of another column and put this value in a third column, and this value will be evaluated for each retrieved record?

"How to perform an opertaion on two columns in a report and insert the result in a third column?"

FYI: I'm using CrystalReport Designer embedded with VisualStudio.NET 2005.

Answer 1

First you need to create formula (with content like "{table.commission}/{table.fare}*100"). I hope next MSDN link will help you (I personally have never used embedded variant of CRD):

Crystal Reports Basic for Visual Studio Formula Overview