How we can calculate the sum of two different columns in Crystal reports?

Question

How we can calculate the sum of two different columns in Crystal reports . For exapme in First column (Filed qty etc) values are 5 & 2 and in second column (Field price etc) values are 6 & 3. Then answer show in third column (sum etc) 11 and 5 but how we can in crystal.

Answer 1

Create the following formula in your report:

// Cost
{YOURTABLENAME.QTY} * {YOURTABLENAME.PRICE}

Insert the Cost formula in the details section of your report. If you have group footers or report footer in which you want to display the Cost subtotal, then insert a summary of the Cost formula into each footer section that you wish to have a subtotal or grand total.