View calc and multiple field collection lines
Finally, I found a way to make it work. Although, maybe it's not a good solution but it worked.
Here is steps:


Find file views_calc_table.inc in views_calc module directory.
Change if ($query_alias == 'unknown') { to if ($query_alias ==
'unknown' || $field-&gt;field_info['type'] == 'field_collection') { in
line 238 under function add_aggregation_fields(&amp;$view)


Remind，never hack core!