Views Summarize Won't Sum when field is output as link (D7)

Question

I'm using Views Summarize module for one of my views. I need to output the field as link and sum them up, but the total is displayed as $0. When I uncheck the output the field as link option, the total is displayed correctly.

http://i.stack.imgur.com/SNK0h.png

Anyone has a solution for this?

Answer 1

Have you seen this issue on drupal.org: http://drupal.org/node/1880450?

It looks like this is actually a bug in the module - not anything you're doing wrong. However, there seems to be a user-submitted patch that fixes issues with decimals, currency, etc that you can try out...

Answer 2

I came up with my own solution to this problem. All you need to do is to modify the module file.

Within the foreach ($data as $val) add this right after

if (strpos($val, '</a>') !== false) {
  preg_match('/<a ?.*>(.*)<\/a>/', $val, $value);
  $val = $value[1];
}