Reputation: 61
how to calculate {SUM} of multiple columns into a one column in In my Crystal reports.
Total=(VAT+TAX)
Upvotes: 0
Views: 22415
Reputation: 9101
ok this how in general it works:
Place your data in detail section and take simmary in report footer, You can take that by right click ojn field and use insert summary option.
Now create a formula @Total
sum(Vat)+sum(tax)+sum(duty) //you can select the summary fields from report fields
Place the formula in report footer
Upvotes: 7