I am trying to create a very simple orders report and the Views calc sum doesn't work on the order totals. Count works fine but sum doesn't. I have included the view that I have created. It just has 2 fields for display. Any assistance would be greatly appreciated.

Files: 
CommentFileSizeAuthor
orders_with_total.view_.txt10.19 KBsher1

Comments

I am also having this issue - I'd love to have this sum correctly - let me know if I can help!

Component:Documentation» Code
Category:support» feature

Hello sher1 and scarr,

I found the way to get sum of order total filed.

First add the filed to views calc
go to admin/structure/views_calc
Base table : Commerce Order
Label : vc Order total (give some name)
Calculation : %field_data_commerce_order_total.commerce_order_total_amount / 100
Format : decimal (2)
Custom function : (I do not know use of this option)
[Save]

Then go to your view and edit it.
Add field : vc Order total

Go to Settings for 'Views Calc Table' and select 'Display calculation' for field 'vc Order total'

You will see sum total for order total field.

Hope this helps you.